Sponsored Content
Full Discussion: Parsing Log File help
Top Forums Shell Programming and Scripting Parsing Log File help Post 302850511 by linuxnew on Thursday 5th of September 2013 01:00:23 AM
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..
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Log(4)							     Kernel Interfaces Manual							    Log(4)

NAME
Log, .Log - Contains the uucp program log files SYNOPSIS
/usr/spool/uucp/.Log DESCRIPTION
The /usr/spool/uucp/.Log directories contain uucp program log files. The uucp program normally places status information about each trans- action in the appropriate log file each time you use the networking utilities facility. All transactions of the uucico and uuxqt daemons are logged in files named for the remote system concerned. The files are stored in a subdirectory of the /usr/spool/uucp/.Log directory named for the daemon involved. Thus, the log files are named with a form of the following: /usr/spool/uucp/.Log/DaemonName/SystemName The uucp and uuto commands call the uucico daemon. The uucico daemon activities for a particular remote system are logged in the System- Name file in the /usr/spool/uucp/.Log/uucico directory on the local system. The uux and uusend commands call the uuxqt daemon. The uuxqt daemon activities for a particular remote system are logged in the SystemName file in the /usr/spool/uucp/.Log/uuxqt directory on the local system. When more than one uucp process is running, however, the system cannot access the standard log file, so it places the status information in a file with a .Log prefix that covers just the single transaction. The uucp program can automatically append the temporary log files to a primary log file. This is called compacting the log files, and is handled by the uudemon.cleanu command, a shell procedure, which combines the log files of the activities of the uucico and uuxqt daemons on a system and stores them in the /usr/spool/uucp/.Old directory. The default is for the uudemon.cleanu command to save log files that are 2 days old. This default can be changed by modifying the appro- priate line in the shell script. If storage space is a problem on a particular system, reduce the number of days that the files are kept in the individual log files. The uulog command can be used to view the uucp program log files. RELATED INFORMATION
Daemons: cron, uucico(8), uusched(8) Commands: uucp(1), uudemon.cleanu(4), uulog(1), uusend(1), uuto(1), uux(1) delim off Log(4)
All times are GMT -4. The time now is 10:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy