Getting the lines between last occurrence of two patterns

rvz · #1 (**permalink**) 02-14-2008

Hi
I am new shell scripting, i need help on the follwoing
I have a application log file, the application is called on cron, the log includes a "started" and "finished" lines repeatedly. I need to get the log of the for the latest run of the application.
Sample log file

Started
adfa
fadfa
Finished
Started
asdlkfjal
asfdslaj
asdfaf
afda
Finished
Started
alsfda
Finished

In this log how to do i get the lines between the last occurence of Started and Finished

maverix · #2 (**permalink**) 02-14-2008

Try this

tail +`grep -in "Started" <logFile> | tail -1 | awk -F: '{print $1}'` <logFile>

cheers
maverix

rvz · #3 (**permalink**) 02-14-2008

thank you very much
it is working fine
Can you explain your script for my understanding

maverix · #4 (**permalink**) 02-14-2008

good that you found it useful!!!

check out the man pages for tail, awk and grep to understand how it works.
In particular, check the switches I've used for each command.

Don't think I am being rude to you.
You must have heard the good old story where the fisherman taught a starving person to fish, rather than giving him few of his catch :-)

cheers
maverix

rvz · #5 (**permalink**) 02-14-2008

Quote:

Originally Posted by maverix

good that you found it useful!!!

check out the man pages for tail, awk and grep to understand how it works.
In particular, check the switches I've used for each command.

Don't think I am being rude to you.
You must have heard the good old story where the fisherman taught a starving person to fish, rather than giving him few of his catch :-)

cheers
maverix

I understood your usage of command.

bakunin · #6 (**permalink**) 02-14-2008

I hope i have understood you correctly: regular expressions can be made to apply only on a limited group of lines:

Code:

sed -n '/start/,/finish/ {
            p
        }

will start printing lines (the "p" command) on the line containing "start" and continue to print the lines until it finds a line containing "finish", when it will stop printing them, until it again encounters a line containing "start", etc.

To print only the last group of lines is a bit tricky: copy everything in one such group to the holdspace, overwriting it every time a new group starts. Upon reaching the last line output the hold space and you are done.

Code:

sed -n '/^Finished/ {
               H
        }
        $ {
               x
               p
        }
        /^Started/,/^Finished/ {
               /^Started/ {
                     h
               }
               /^Started/ !{
                     H
               }
        }'

I hope this helps.

bakunin

rvz · #7 (**permalink**) 02-14-2008

Quote:

Originally Posted by bakunin

I hope i have understood you correctly: regular expressions can be made to apply only on a limited group of lines:

Code:

sed -n '/start/,/finish/ {
            p
        }

will start printing lines (the "p" command) on the line containing "start" and continue to print the lines until it finds a line containing "finish", when it will stop printing them, until it again encounters a line containing "start", etc.

To print only the last group of lines is a bit tricky: copy everything in one such group to the holdspace, overwriting it every time a new group starts. Upon reaching the last line output the hold space and you are done.

Code:

sed -n '/^Finished/ {
               H
        }
        $ {
               x
               p
        }
        /^Started/,/^Finished/ {
               /^Started/ {
                     h
               }
               /^Started/ !{
                     H
               }
        }'

I hope this helps.

bakunin

How do i use this script, where to put my logfile name

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to get lines in between Patterns?	racbern	Shell Programming and Scripting	11	04-23-2008 07:28 AM
how to grep for lines between 2 give patterns?	melanie_pfefer	Shell Programming and Scripting	1	04-03-2008 11:38 AM
Replace second occurrence only	lyoncc	Shell Programming and Scripting	5	12-26-2007 11:21 PM
awk + last occurrence	agibbs	UNIX for Dummies Questions & Answers	2	10-06-2007 03:32 PM
Grep for the same occurrence or maybe Sed	hcclnoodles	Shell Programming and Scripting	4	09-12-2002 12:25 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: