[SOLVED] how to select date and some specific data from a log file

shwhooda · 06-13-2012, 11:39 PM

Hi,
I am new to Linux. I have to search a log file and extract the date and "UPDATE_STOP" data to a csv file in 2 columns.
This is the sample from my log file :

RTS_WS974 05/06/12 01:04:28.801 [20:23:38.450] recv :4620
RTS_WS974 05/06/12 01:04:30.863 [20:23:41.450] MethodName : UPDATE_STOP

So my requirement is :
>> Output CSV File
Column A Column B
05/06/12 01:04:30.863 MethodName : UPDATE_STOP

There is other data in the file which i dont need.
Please help me in getting the output. I tried grep command however, i am able to extract the only the method but not sure how to extract the varying time.

chrism01 · 06-13-2012, 11:48 PM

Here's a very simple method

Code:

grep UPDATE_STOP logfile|awk '{print  $2,$3,$5,$6,$7}'

# if you actually want a comma eg before Method..
grep UPDATE_STOP logfile|awk '{print  $2,$3",",$5,$6,$7}'

http://www.grymoire.com/Unix/Awk.html

shwhooda · 06-25-2012, 07:56 PM

Quote:

Originally Posted by chrism01

Here's a very simple method

Code:

grep UPDATE_STOP logfile|awk '{print  $2,$3,$5,$6,$7}'

# if you actually want a comma eg before Method..
grep UPDATE_STOP logfile|awk '{print  $2,$3",",$5,$6,$7}'

http://www.grymoire.com/Unix/Awk.html

Hi,
Please let me know how to this can be processed using python.
I tried using read file function and printing line when it finds "UPDATE_STOP" but nothing gets printed.
Best Regards,
Shweta