14

Calculating the epoch time from standard time using awk and calculating the duration

view full story
linux-howto

http://www.unix.com – Hi All, I have the following time stamp data in 2 columns Code:     Date    TimeStamp(also with milliseconds) 05/23/2012 08:30:11.250 05/23/2012 08:30:15.500 05/23/2012 08:31.15.500 . . etc From this data I need the following output. Code: 0.00( row1-row1 in seconds) 04.25( row2-row1 in seconds) 64.25(row3-row1 in seconds) I tried to convert the second column into seconds using HH*60*60+MM*60+SS+MS(milliseconds) formula and subtracting line by line but the problem is if the date changes at some row, I don't know how to proceed. May be converting ecah colum (HowTos)

jiqi2's picture
Submitted by jiqi2 on 05/23/2012 – Made popular on 05/23/2012

Stories similar to Calculating the epoch time from standard time using awk and calculating the duration

Hi,

I have a requirement to append = in particular row in csv file. Data in csv is as follow:

Code: row1,a,a,a row2,b,b,b row3,c,c,c row4,d,d,d csv should be modified at row3 and no. of columns are not fixed but rows are. output should be as:

Code: row1,a,a,a row2,b,b,b row3,=c,=c,=c row4,d,d,d = should be appended after comma.

Please help.

I have a text file that contains a big matrix, that columns are split like the following example:

col1 col2 col3 row1 .. .. .. row2 .. .. .. row3 .. .. .. row4 .. .. .. row5 .. .. .. row6 .. .. ..

col4 col5 col6 row1 .. .. .. row2 .. .. .. row3 .. .. .. row4 .. .. .. row5 .. .. .. row6 .. ..

Pivoting the data 25 weeks 1 day ago

Hello Unix guys,

I have the following 4 column data, which is a output of db2 select query:

Need to pivot the data.

sample Input: Year Month Country Counts

Code:       2012 Aug    Canada        114       2012 Aug    USA          92       2012 Aug    Mexico  &n

I needed some help in adding a duration (in seconds) to a start time (in hhmmss format) and a start date (in mmddyy format) in order to get an end date and end time. The concept of a leap year is also to be considered while incrementing the day. The code/ function that I have formed so far is as follows, but there appears to be an error in the function calling.

Extremely slow machine 3 years 16 weeks ago

Hello,

I run F12. Since some days my laptop has become very sluggish. In Mozilla, switching between the tabs takes like seconds instead of fraction of a second. Also minimizing and mximizing windows takes long. Switching between the windows too takes long. Now I can't see the cursor while typing this post.

awk format layout 50 weeks 1 day ago

Hi Gurus,

I've a sample output from a script with a header as shown below.

The formatting is a little bit out of alignment when it's sent out via email.

Sample output:

Code: Label                Date                New Data  #AB              Removed   

Calculate Beta or Slope ! 33 weeks 5 days ago

Hello Group,

I would request your help to build a shell script that can calculate the beta or slope between a two series of investment instruments (i.e S&P 500 and Silver). I have a source files of data (First - Date, Second (Value1) and Third (Value 2) columns)

Code: Date    S&P 500    S&P 500    Silver    Silver 9/4/2012    140.

Shell script - precent value 48 weeks 4 days ago

Hello,

I have example data like below:

Code:     39 ,2012/01,0     22 ,2012/02,0       2 ,2012/02,1     23 ,2012/03,0       3 ,2012/03,1     16 ,2012/04,0       2 ,2012/04,1       8 ,2012/05,0       2 ,2012/05,1 It is possible (awk, sed, bash) to calculate output like below

Dear Expert,

Below code is for to take the backup of database by daily time stamp.