|
latest status of an field in a log file
Hi
I have got a log file which is like:
id status
---------------------
12345 status1.true
12345 status2.true
12345 status3.false
12345 status4.true
23452 status5.true
23452 status6.true
23452 status7.false
65243 status9.true
.
.
.
.
.
.
.
and so on
The id field shows the id of an event while as the status field shows
the status of the id to be true or false.
For a particular id I want to know the status as true or false.
The log is sorted by timestamp
Eg. here in my log the status for 12345 would be true
while as the status for 23452 would be false
and for 65243 it would be true.
Right now I have to manually look at the last entry for the
particular id to find it's status.
Is there another way around to do this.
Regards
enc
|