hi Michael,


Thanks for your help. The command is executing. but where should i check the output.

The sample lines in the file to be searched is

Code:

 
BEGIN TEST
   NAME "A0001_ext_PBIG_Override"
   DateModified "2010-09-23"
   TimeModified "09.15.32"
BEGIN LOOP
      NAME "V0"
      PrimaryType "CContainerView"
      Name "Job"
OR
B.DB_NAME='TEST_DB'
END LOOP
END TEST
BEGIN TEST
   NAME "B0001_ext_Dump"
   DateModified "2010-09-24"
   TimeModified "09.15.32"
BEGIN LOOP
      NAME "V0"
      PrimaryType "CContainerView"
      Name "Job"
OR
c.TEST_NAME='VALUE'
END LOOP
END TEST

in the above sample i want to search for the word "TEST_DB" (i.e pattern3)
once pattern3 is found i have to go above and search the word "BEGIN TEST" (i.e pattern1) and if pattern1 is found then i have to search NAME (i.e pattern2) which comes immediately after pattern1. if pattern2 is found then i want to capture the job name next to pattern2 i.e "A0001_New_Dump" in another file and finally go and search the last word "END TEST" (i.e pattern4). searching for pattern4 will bring the search complete in one job.

after END_TEST then next job will start with BEGIN_TEST. so like this i have to find in which jobs the pattern3 is used.