11

Parse variable length status,timestamp CSV

view full story
linux-howto

http://www.unix.com – I have the output of a process which on status change of the object being processed appends status,timestamp to the record in the text file... so i end up with output something like: Code: task123,TERMINAL,glob,5,INITIAL,2012-02-27 16:48:07,PREPARING,2012-02-27 16:49:06,SCHEDULED,2012-02-27 16:49:06,TRANSLATING,2012-02-27 16:49:07,TERMINAL,2012-02-27 16:50:52 task345,COMPLETE,glob2,6,INITIAL,2012-02-27 16:48:07,PREPARING,2012-02-27 16:49:06,SCHEDULED,2012-02-27 16:49:07,TRANSLATING,2012-02-27 16:49:22,LOADING,2012-02-27 16:50:53,COMPLETE,2012-02-27 16:50:53 what i'd like to do is (HowTos)

ziyi's picture
Submitted by ziyi on 02/28/2012 – Made popular on 02/28/2012

Stories similar to Parse variable length status,timestamp CSV

when i run this command:

Code: tail -200 /var/log/httpd/access_log | awk -F'[][]' '{sub(/:[^:]*$/,"",$2);print $2}' i get:

Code: 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 13/Aug/2012:20:56 now i need to alter the awk command

I have an input list of:

Quote:

2/10/2012 9:19 PM EST 2/10/2012 8:48 PM EST 2/16/2012 2:49 PM EST 2/16/2012 6:06 PM EST 2/14/2012 8:30 PM EST 2/13/2012 2:44 PM EST 2/13/2012 6:06 PM EST 2/14/2012 4:36 PM EST 2/11/2012 7:01 PM EST 2/16/2012 11:48 AM EST 2/15/2012 6:16 PM EST 2/13/2012 12:59 PM EST

I am just trying to turn this list into its seconds

Hi

my data is in csv-format ...

Code: ... 13/08/2012,16:30,303.30,5.10,3,2,2,1,9360.0,322 13/08/2012,16:40,305.50,5.00,3,2,2,1,12360.0,322 13/08/2012,16:50,319.90,3.80,3,2,1,0,2280.0 13/08/2012,17:00,326.10,3.50,3,2,1,1,4380.0,321 13/08/2012,17:10,333.00,3.80,3,3,1,0,2280.0 13/08/2012,17:20,330.20,4.50,3,3,2,0,2700.0 13/08/2012,17:30,332.00,4.20,3,3,2,1,5220.0,332 13/08/2012,17:40,334.90,3.

i have a string containing date and time as timestamp= 12-12-2012 16:45:00

I need to reformat it into timestamp= 16:45:00 12-12-2012

How to achieve this in shell script?

Note Please : variable's value is 12-12-2012 16:45:00 and timestamp is the name of variable

#!usr/bin/expect set timestamp "16:45:00 12-12-2012" Now what should i do so value of timestamp will become 12-12-2012 16:45:00 scrip

Hi I have a large csv file with lines like below

Code: Date,Status,orig,dest,in,out,when,where 2012-01-01 00:30:37,I,48,56,23,98,83,34 2012-06-17 15:00:38,I,72,43,12,65,34,12 I will really appreciate if someone can help with a sed script to transpose this to

Code: 2012-01-01 00:30:37,I,orig,48 2012-01-01 00:30:37,I,dest,56 2012-01-01 00:30:37,I,in,23, 2012-01-01 00:30:37,I,out,98 201

The error is 2147746321.

I can see in the mailserver log that it tries, but the connection gets closed.

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

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!

1.

I'm able to upload plain text file (a.txt) to an sftp server, but when I pgp encrypt the file (a.txt.pgp), I get an error:

NOTE:> [10/8/2012 1:43:06 PM] New transfer created for \"c:\FTP\Bin\a.txt.pgp\" <23> STATUS:> [10/8/2012 1:43:06 PM] Transferring file "/uploads/a.txt.pgp"... STATUS:> [10/8/2012 1:43:06 PM] Changing directory to '/