Visit Our UNIX and Linux User Community


Parsing Log File help


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parsing Log File help
# 1  
Old 09-05-2013
Parsing Log File help

Hi,

I am a newbie to scripting.

I have multiple log files (saved as .gz) in a directory that looks like this

Code:
01-01-2013 10:00 pn: 123
01-01-2013 10:00 sn: 987
01-01-2013 10:00 [1] Test1
01-01-2013 10:00 Result: Pass
01-01-2013 10:00 Time: 5:00
01-01-2013 10:00 [2] Test2
01-01-2013 10:00 Result: Fail
01-01-2013 10:00 Time: 10:00
01-01-2013 10:00 Sympton: Bad
01-01-2013 10:00 [3] Test3
01-01-2013 10:00 Result: Pass
01-01-2013 10:00 Time: 20:00

I need to go through all the .gz files in a particular direcory looking for only log files that have a result=fail with specifically "Test2" only. Then output this to another file ideally csv file so I can do some post processing.

I would like the output file to look like this
pn , sn , time to fail
123 , 987 ,10


Moderator's Comments:
Mod Comment Use code tags, thanks.

Last edited by zaxxon; 09-05-2013 at 03:05 AM..
# 2  
Old 09-05-2013
.gz is normally used for gzip-compressed files; then search for matching lines with
Code:
gunzip -c *.gz | fgrep 'Result: Fail'

Otherwise replace gunzip -c with cat.
This loses the information in which file(s) it was found.
# 3  
Old 09-05-2013
What if the log file has multiple fail results, but I want to check if this is Test2 and not Test3 and then print the time it took for Test2 before it failed?
Code:
01-01-2013 10:00 pn: 123
01-01-2013 10:00 sn: 987
01-01-2013 10:00 [1] Test1
01-01-2013 10:00 Result: Pass
01-01-2013 10:00 Time: 5:00
01-01-2013 10:00 [2] Test2
01-01-2013 10:00 Result: Fail
01-01-2013 10:00 Time: 10:00
01-01-2013 10:00 Sympton: Bad
01-01-2013 10:00 [3] Test3
01-01-2013 10:00 Result: Fail
01-01-2013 10:00 Time: 20:00


Last edited by Franklin52; 09-05-2013 at 04:36 AM.. Reason: Please use code tags for code and data samples
# 4  
Old 09-05-2013
Please wrap your code in "code" tags (at the top of the Wiki editor)!
In Linux you can use
Code:
fgrep -B 1 -A 1 'Result: Fail'

The following awk searches for the given test:
Code:
awk '(n==2 && /Time:/) {printf "%s\n%s\n%s\n",bb,b,$0; n=0} (n==1) {if (/Result: Fail/) {b=$0; n=2} else {n=0}} (n==0 && $NF~test) {bb=$0; n=1}' test=Test2


Previous Thread | Next Thread
Test Your Knowledge in Computers #988
Difficulty: Medium
OpenBSD developers were instrumental in the creation and development of OpenSSH.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

HELP on parsing this log file

Hi, I have a log file that looks like below and I am wanting to know if there is a better way of parsing it from how I am doing it right now. I am looking for when an application service is OFFLINE and ONLINE. This log file is getting written into every 30 minutes ... (1 Reply)
Discussion started by: newbie_01
1 Replies

2. Shell Programming and Scripting

Parsing log file for last 2 hours

I want to parse a log file which i am grepping root user connection but is showing whole day and previous day detail as well. First i want to see last 2 hours log file then after that i want to search particular string. Lets suppose right now its 5:00PM, So i want to see the log of 3:00PM to... (6 Replies)
Discussion started by: learnbash
6 Replies

3. Shell Programming and Scripting

Help Parsing a Log File

Hello all, I am new to scripting and I have written a script that performs an Rsync on my NAS and then moves on to send me an email with the status etc. The problem is that I think Rsync is taking to long to complete and the IF statement is timing out, as it doesn't appear to move on. Here... (1 Reply)
Discussion started by: Mongrel
1 Replies

4. Shell Programming and Scripting

Script for Parsing Log File

Working on a script that inputs an IP, parses and outputs to another file. A Sample of the log is as follows: I need the script to be able to input IP and print the data in an output file in the following format or something similar: Thanks for any help you can give me! (8 Replies)
Discussion started by: Winsarc
8 Replies

5. UNIX for Dummies Questions & Answers

Parsing log file continuously

Hi i have a log file, which keeps appending, i want to find "exceptions" in that log file and copy those exceptions to another file. i am using grep exception filename >> location where to copy but as the file is appending, am not able to view. i am using tail -f command , ... (5 Replies)
Discussion started by: rchaitanya
5 Replies

6. Shell Programming and Scripting

Log file text parsing

I'm new to scripting and was wondering if there was a way to accomplish what I want below using shell script(s). If there is a log file as follows, where the id is the unique id of a process, with the timestamp of when the process began and completed displayed, would it be possible to find the... (3 Replies)
Discussion started by: dizydolly
3 Replies

7. UNIX for Dummies Questions & Answers

parsing a log file

I need help in parsing the following log files. 10 Apr 2009 0:16:16 * name: Tuna Belly Format: Well done, Price: 999 only 10 Apr 2009 0:16:16 * name: Roast Beef Format: Raw, Price: 55 c 10 Apr 2009 0:16:16 * name: Pasta Format: Dry, Price: 88.43 only etcetc I need to parse this... (8 Replies)
Discussion started by: izuma
8 Replies

8. UNIX for Dummies Questions & Answers

Script for parsing details in a log file to a seperate file

Hi Experts, Im a new bee for scripting, I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Discussion started by: pingnagan
2 Replies

9. Shell Programming and Scripting

Help with script parsing a log file

I have a large log file, which I want to first use grep to get the specific lines then send it to awk to print out the specific column and if the result is zero, don't do anything. What I have so far is: LOGDIR=/usr/local/oracle/Transcription/log ERRDIR=/home/edixftp/errors #I want to be... (3 Replies)
Discussion started by: mevasquez
3 Replies

10. Shell Programming and Scripting

Parsing a Log file

Hi All, I'm deffently not a Unix specialist so be Gentel. I need to parse a Log file that looks like that: 2006-06-12 01:00:00,463 ERROR {cleanLoggersFiles} General Error comverse.compas.shared.exceptions.SystemParametersException: Error in reading parameter FileLocation at... (4 Replies)
Discussion started by: tbirenzweig
4 Replies

Featured Tech Videos