debug repeat entries with a random function and erase the rest
Good morning. I have a txt file with 4 comma delimited fields: Date,
ID, Time and I/O. The fields are generated by a biometric time
attendance system. The main problem I have is debugging repeat entries.
For example,
If an employee punches in twice, I'd have the following:
11/27/2006 16 16:31:27 2
11/27/2006 16 16:32:21 2
What I want is to select a random entry of these within a 5 minute
interval and erase the rest. Any ideas on how I might achieve this? Any
better ideas on how to accomplish this?
Cheers and thx.
|