Shell Programming and Scripting

Hi All,

I have received new business requirement. I have mentioned below that requirement. As I am new to Unix, Please guide me how to do this.

I have a file. It contains Header record , few data records and trailer record.
1. Header records contains the transaction date(yyyy-mm-dd)
2. Trailer record contains record count of the file
3. Another file contains the last ETL processed date

Condition 1: Take the date from the header record and compare with the last ETL process date in another file, file transaction date should be greater than last ETL Process date

Condition 2: Take record count from the trailer file and compare with the actual number of data records in the file. Both the counts should match

Output : If the condtion1 and condition2 are matching then only we have process the file.

How to write a script above mentioned? and help is really appreciated.

I have checked in search forum. I have not find any Information related to my Issue. Any Input is really helpful for me

strange....

anyway post the sample data and just tell about what logic you have to achieve this

File1.txt
Columns:

Header - Transaction Date - currentdate(2011-15-09)
Trailer - TotCnt - 2500

File2.txt

Last_ETL_Proccess_date
(2011-10-09)

Logic:

1. Take the date from the header record and compare with the last ETL process date in another file, file transaction date should be greater than last ETL Process date

2: Take record count from the trailer file and compare with the actual number of data records in the file. Both the counts should match