UNIX for Dummies Questions & Answers

Hello:

I'm a very newbee at UNIX/AIX.
What i want to do is to tail a file from the bottom until a certain string is found and write all the lines after the found string to another file.
I've tried out a lot of combination with tail and grep but doesn't find the good one.

Could someone help me or give me a hint with this issue?

Many thanks in advance,
Felix

Felix,
Could you please give us a sample of input and output?
Thanks

INPUT lOG:-> this is the file i want to serach -> string to searchatabase Connection Information

Database Connection Information

Database server =
SQL authorization ID =
Local database alias =

Number of rows read = 18724
Number of rows skipped = 0
Number of rows loaded = 18724
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 18724
DB20000I The RUNSTATS command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
B20000I The RUNSTATS command completed successfully.



Database Connection Information

Database server =
SQL authorization ID =
Local database alias =
Number of rows read = 18724
Number of rows skipped = 0
Number of rows loaded = 18724
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 18724
DB20000I The RUNSTATS command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The RUNSTATS command completed successfully.
---------- --------------- -------------- ------------- -------------
The Output file i want to have is only the first part of it beginning from the buttom:
Database Connection Information

Database server =
SQL authorization ID =
Local database alias =
Number of rows read = 18724
Number of rows skipped = 0
Number of rows loaded = 18724
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 18724
DB20000I The RUNSTATS command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The SQL command completed successfully.
DB20000I The RUNSTATS command completed successfully.

Thank you.

Felix,
See if this works for you:

Code:

mBaseStr='Database Connection Information'
mLastOccur=`egrep -n "$mBaseStr" input_file | tail -1`
mFromLine=`echo $mLastOccur | cut -d':' -f1`
tail +$mFromLine input_file

It works fine.

Thank you very much indeed.