Shell Programming and Scripting

I am trying to create a script to search for a string within a file, and if found, return the next two lines.

Example file:-

msj
mh
query
return this 1
return this 2
mjk
mhj
query
return this 3
return this 4

So the script would identify the string "query" and then return the lines "return this 1", "return this 2", "return this 3" and "return this 4".

How best to do this?

Regards, Dave.

Actually, I tried the following:-

awk 'c&&c--;/query/{c=2}' inputfilename

and it worked fine for me!

grep query -A 2 inputFileName | grep -v query

The -A option to grep is not standard.

Code:

cat filename | sed -n '/query/{n
p
n
p
}'

cat is an unnecessary external command:

Code:

sed -n '/query/{n;p;n;p;}' filename

I am currently using the following query to print the lines AFTER a pattern:

awk '/Statement Execution Time/{c=10}c&&c--'

Can this be adapted to print the lines after a pattern, up to a second pattern? I want the lines after (and including) "Statement", up to (not including) "Stack Trace". There may not always be the same number of lines between the two.

(Example File)
Statement Execution Time
Select Distinct.......
From.........
Where..........
Order By........
Stack Trace
config.java.feeds.invoices