UNIX for Dummies Questions & Answers

Hello all,
Would appreciate if someone can help me out on the following requirement.

INPUT FILE:

--------------------------

TPS REPORT

abc def ghi
jkl mon pqr
stu vrs lll

END OF TPS REPORT


TPS REPORT

field1 field2 field3
field4 field5 field6

END OF TPS REPORT

------------------------------------

Considering evrything betwee TPSREPORT & END OF TPS REPORT as a record,
I want to print field 2 in from the second line in each record.

DESIRED OUTPUT:

mon
field5

Code:

awk '/^TPS REPORT$/ {getline; getline; getline; print $2}' infile

Thank you for your reply, it did not work when I tried to implement it as is.
I could get the second field from second line using the following code, but I cannot repeat it for every record in the file

`awk 'NR==2' $file | awk '{print $2}'`

Code:

root@isau02:/data/tmp/testfeld> cat infile
TPS REPORT

abc def ghi
jkl mon pqr
stu vrs lll

END OF TPS REPORT


TPS REPORT

field1 field2 field3
field4 field5 field6

END OF TPS REPORT
root@isau02:/data/tmp/testfeld> awk '/^TPS REPORT$/ {getline; getline; getline; print $2}' infile
mon
field5

Thank You! Zaxxon ...yes...it works as your output shows...I was having issues with my input file as it had ^z characters which I did not see before.
I fixed it now and this works.....appreciate your help

zaxxon, I was trying for something similar and gave a simplified example to show what I needed.I actually am doing something like this ,I am not getting the needed output..could you help me on this. Thank you

Input file:

A
TPS REPORT SOME OTHER DATA

abc def ghi
jkl mon pqr
stu vrs lll

END OF TPS REPORT

A
TPS REPORT SOME OTHER DATA

field1 field2 field3
field4 field5 field6

END OF TPS REPORT


Output needed:

Considering evrything between TPS REPORT & END OF TPS REPORT as a record,
I need first field of first line and second field of second line for each record as output.For the ipfile above, desired output is as follows:

abc mon
field1 field5

Here is what I tried and the output I am getting

f1=`awk '/^TPS REPORT/ {getline;getline; print $1}' $ipfile`
f2=`awk '/^TPS REPORT/ {getline; getline; getline; print $2}' $ipfile`
echo $f1
echo $f2


OUTPUT:
abc field1
mon field5