Sorry, I should have explained more explain more on my previous thread.
Every time a record is inserted into the log a Date is entered 1st followed by a line(s) detailing the change.
Some of the less interesting things I don't want to see (including the date that went with the item).
In brief what I want it to convert the following:
Tue Aug 20 08:02:18 2002
Boring data
Tue Aug 20 08:02:18 2002
Boring data
Tue Aug 20 09:00:04 2002
Good data 1
Good data 2
Tue Aug 20 09:00:09 2002
Good data 3
Tue Aug 20 09:00:21 2002
Boring data
Boring data
Tue Aug 20 09:00:23 2002
Good data 4
Into:
Tue Aug 20 09:00:04 2002
Good data 1
Good data 2
Tue Aug 20 09:00:09 2002
Good data 3
Tue Aug 20 09:00:23 2002
Good data 4
The number of lines of data lines between dates can vary. I presume I will have to check for colons on the 14th & 17th column to identify a date?
Thanks again
dklloyd
Every time a record is inserted into the log a Date is entered 1st followed by a line(s) detailing the change.
Some of the less interesting things I don't want to see (including the date that went with the item).
In brief what I want it to convert the following:
Tue Aug 20 08:02:18 2002
Boring data
Tue Aug 20 08:02:18 2002
Boring data
Tue Aug 20 09:00:04 2002
Good data 1
Good data 2
Tue Aug 20 09:00:09 2002
Good data 3
Tue Aug 20 09:00:21 2002
Boring data
Boring data
Tue Aug 20 09:00:23 2002
Good data 4
Into:
Tue Aug 20 09:00:04 2002
Good data 1
Good data 2
Tue Aug 20 09:00:09 2002
Good data 3
Tue Aug 20 09:00:23 2002
Good data 4
The number of lines of data lines between dates can vary. I presume I will have to check for colons on the 14th & 17th column to identify a date?
Thanks again
dklloyd