Sponsored Content
Full Discussion: Sed to parse log file
Top Forums Shell Programming and Scripting Sed to parse log file Post 302633151 by itkamaraj on Tuesday 1st of May 2012 11:55:19 AM
Old 05-01-2012
Code:
$ awk -F": " '/Custodian/{c=$2}/Export Path/{p=$2}/Matched File/{m=$2}/File Size/{s=$2}/Original Path/{o=$2} {if(c && p && m && o && s){printf("\"%s\",\"%s\",\"%s\",\"%s\",\"%s\"\n",c,p,m,s,o);m=s=o=0;}}' test.txt
"Jim_Foo-HDD1-FOO-1234","N:\FOO-1234\Foo_Foo","foo_file1.pdf","640","foopath\foopath\foopath\foobar\foo_file.pdf"
"Jim_Foo-HDD1-FOO-1234","N:\FOO-1234\Foo_Foo","foo_file2.pdf","123","foopath\foopath\foopath\foobar\foo_file.pdf"

This User Gave Thanks to itkamaraj For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To parse through the file and print output using awk or sed script

suppose if u have a file like that Hen ABCCSGSGSGJJJJK 15 Cock ABCCSGGGSGIJJJL 15 * * * * * * : * * * . * * * : Hen CFCDFCSDFCDERTF 30 Cock CHCDFCSDHCDEGFI 30 * . * * * * * * * : * * :* : : . The output shud be where there is : and . It shud... (4 Replies)
Discussion started by: cdfd123
4 Replies

2. Shell Programming and Scripting

Parse out known messages from a log file

I am looking for a script to do the following. I have a large log file that contains hundreds of warnings, a lot of which can be ignored. The tool doesn't allow me to suppress it, so I like to parse it out from the log file and isolate just the new messages/warnings, based on an exception file. ... (12 Replies)
Discussion started by: cdn2008
12 Replies

3. Shell Programming and Scripting

sed command to parse Apache config file

Hi there, am trying to parse an Apache 'server' config file. A snippet of the config file is shown below: ..... ProxyPassReverse /foo http://foo.example.com/bar ..... ..... RewriteRule ^/(.*) http://www.example.com/$1 RewriteRule /redirect https://www.example1.com/$1 ........ (7 Replies)
Discussion started by: jy2k7ca
7 Replies

4. Shell Programming and Scripting

sed parse small xml file

I have a tmp.xml file like: <?xml version="1.0" encoding="UTF-8"?> <Response> <Ip>193.143.121.198</Ip> <Status>OK</Status> <CountryCode>PL</CountryCode> <CountryName>Poland</CountryName> <RegionCode>82</RegionCode> <RegionName>Pomorskie</RegionName> <City>Gdansk</City> ... (9 Replies)
Discussion started by: unclecameron
9 Replies

5. Shell Programming and Scripting

parse a log file and remember last line

Hi all: I'm working on a HPUX 11.23 system and I am needing to parse a tomcat-jakarta log file for memory use. Getting the desired data is easy, assuming the log file does not grow. This file grows constantly and I want to check it q 5 min. The next check will pick up from where it left off 5... (4 Replies)
Discussion started by: raggmopp
4 Replies

6. Shell Programming and Scripting

Parse the log file

./abc.sh started at Sun Oct 24 06:42:04 PDT 2010 Message: ======= Summary Report of NAME count ----------------------------------------------------------------- Below is the output of the SQL query :- NAME COUNT... (2 Replies)
Discussion started by: sandy1028
2 Replies

7. Shell Programming and Scripting

parse log with sed

I've been searching for an hour on how to parse a file like this: 10.200.5.83 - - "GET /portal/edits.js HTTP/1.1" 200 24324 10.200.5.83 - - "GET /portal/objects/PortalConfig.js HTTP/1.1" 200 12187 10.200.5.84 - - "GET /portal/objects/CommonDialog.js HTTP/1.1" 200 8283 10.200.5.84 - - "GET... (4 Replies)
Discussion started by: dba_frog
4 Replies

8. Shell Programming and Scripting

sed parse a lign into a new sql file

Hi everyone, another question while using sed. my sed statement should parse every line in a file and store all "i" variable item a a new file. any wrong arguments here? Thanks a million. task_name => name, object_type => 'TABLE', attr1 => 'TestR3', attr2 => '$i', for i... (4 Replies)
Discussion started by: sundaygeek
4 Replies

9. Shell Programming and Scripting

Parse A Log File

Hello All, Below is the excerpt from my Informatica log file which has 4 blocks of lines (starting with WRITER_1_*_1). Like these my log file will have multiple blocks of same pattern. WRITER_1_*_1> WRT_8161 TARGET BASED COMMIT POINT Thu May 08 09:33:21 2014... (13 Replies)
Discussion started by: Ariean
13 Replies

10. Shell Programming and Scripting

Parse log file to insert into database

I have a log file that's created daily by this command: sar -u 300 288 >> /var/log/usage/$(date "+%Y-%m-%d")_$(hostname)_cpu.log It that contains data like this: Linux 3.16.0-4-amd64 (myhostname) 08/15/2015 _x86_64_ (1 CPU) 11:34:17 PM CPU %user %nice ... (12 Replies)
Discussion started by: unplugme71
12 Replies
DPKG::Log(3pm)						User Contributed Perl Documentation					    DPKG::Log(3pm)

NAME
DPKG::Log - Parse the dpkg log VERSION
version 1.20 SYNOPSIS
use DPKG::Log; my $dpkg_log = DPKG::Log->new('filename' => 'dpkg.log', 'parse' => 1); DESCRIPTION
This module is used to parse a logfile and store each line as a DPKG::Log::Entry object. METHODS
$dpkg_log = DPKG::Log->new() $dpkg_log = DPKG::Log->new('filename' => 'dpkg.log') $dpkg_log = DPKG::Log->new('filename' => 'dpkg.log', 'parse' => 1 ) Returns a new DPKG::Log object. If parse is set to a true value the logfile specified by filename is parsed at the end of the object initialisation. Otherwise the parse routine has to be called. Filename parameter can be omitted, it defaults to /var/log/dpkg.log. Optionally its possible to specify from or to arguments as timestamps in the standard dpkg.log format or as DateTime objects. This will limit the entries which will be stored in the object to entries in the given timerange. Note that, if this is not what you want, you may ommit these attributes and can use filter_by_time() instead. By default the module will assume that those timestamps are in the local timezone as determined by DateTime::TimeZone. This can be overridden by giving the argument time_zone which takes a timezone string (e.g. 'Europe/Berlin') or a DateTime::TimeZone object. Additionally its possible to override the timestamp_pattern by specifying timestamp_format. This has to be a valid pattern for DateTime::Format::Strptime. $dpkg_log->filename $dpkg_log->filename('newfilename.log') Get or set the filename of the dpkg logfile. $dpkg_log->parse $dpkg_log->parse('time_zone' => 'Europe/Berlin') $dpkg_log->parse('time_zone' => $dt_tz ) Call the parser. The time_zone parameter is optional and specifies in which time zone the dpkg log timestamps are. If its omitted it will use the default local time zone. Its possible to specify either a DateTime::TimeZone object or a string. @entries = $dpkg_log->entries; @entries = $dpkg_log->entries('from' => '2010-01-01.10:00:00', to => '2010-01-02 24:00:00') Return all entries or all entries in a given timerange. from and to are optional arguments, specifying a date before (from) and after (to) which entries aren't returned. If only to is specified all entries from the beginning of the log are read. If only from is specified all entries till the end of the log are read. $entry = $dpkg_log->next_entry; Return the next entry. @entries = $dpkg_log->filter_by_time(from => ts, to => ts) @entries = $dpkg_log->filter_by_time(from => ts) @entries = $dpkg_log->filter_by_time(to => ts) @entries = $dpkg_log->filter_by_time(from => ts, to => ts, entry_ref => $entry_ref) Filter entries by given from - to range. See the explanations for the new sub for the arguments. If entry_ref is given and an array reference its used instead of $self->{entries} as input source for the entries which are to be filtered. ($from, $to) = $dpkg_log->get_datetime_info() Returns the from and to timestamps of the logfile or (if from/to values are set) the values set during object initialisation. SEE ALSO
DPKG::Log::Entry, DateTime, DateTime::TimeZone AUTHOR
Patrick Schoenfeld <schoenfeld@debian.org>. COPYRIGHT AND LICENSE
Copyright (C) 2011 Patrick Schoenfeld <schoenfeld@debian.org> This library is free software. You can redistribute it and/or modify it under the same terms as perl itself. perl v5.10.1 2011-02-26 DPKG::Log(3pm)
All times are GMT -4. The time now is 10:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy