I have a large log file. I want to keep 1 week worth of records. This is what part of file looks like:

Oct 04 09:16:59 [INFORMATION] Order intfc ended normally on 10/04/2004 at 09:16.
Oct 04 09:16:59 [INFORMATION] ------------------------------------------------
Oct 04 09:16:59 [INFORMATION] TM: Program <Iordload> ended (normal, exit <0>).

********

WARNING: The following errors occurred running sqlldr...

SQL*Loader: Release 9.2.0.5.0 - Production on Mon Oct 4 09:16:57 2004

Oct 04 09:32:04 [INFORMATION] Access code is valid.
Oct 04 09:32:04 [INFORMATION] Task master: Program <Iordload> started.
Oct 04 09:32:04 [WARNING] Ord <B394588-SFI>: cannot modify ord that does not exist. Ord will be added with <I> status.


Is there a way to truncate the records that are less than today's date - 7 days? I think it would be easier to do if each and every record began with a date, but in this file they don't. Any help would be greatly appreciated.

What seems to me that you are trying to Load records
into a database using SQL Loader.
What am I not getting is that why are you truncating the log
to have records for a week?
Are you trying to spilt the log into data of 1 week?

Enc.

On second thoughts!!

If you want lines in the log which have the date exactly 1 week from todays date
you can try:

code:
Hope That helps
enc.

This log file gets auto generated by another system of ours. I was just trying to point out that in this file, not all of the lines have a timestamp associated with them. Maybe it would be easier and better if I could just figure out how to chop off the first X rows from the file.

Once a night do something like...

mv file.6 file.7
mv file.5 file.6
mv file.4 file.5
mv file.3 file.4
mv file.2 file.3
cp file file.2
> file

U can write the log file every day to a new different file based on date format ;


If u do n't have a control of this ......,

Is there any pattern of 'first line' it prints on every day ; Find out the line number using 'grep' ; Let's say that is 'm'

Try for the second day using grep ; Let's say the second day starts with line number 'n'

Seperate the first day logs using head and tail .... between

m and n-1 lines.




Repeast the same thing for other 6 days.

Hope this helps.