remove duplicate lines in file

[jack7974]

Hi
Having a file as follows

Code: [Select]

==================================================
Date           Time         error code      server
======================================================
12-29-08    10:10        121221          server A
12-29-08    10:12        121221          server A
12-29-08    10:10        121221          server B
12-29-08    10:10        121221          server B

Need to remove the duplicate lines with the following conditions
if date=12-29-08 and server=server A .
Must delete the line with old time and keep the latest.

Anyone can suggest

Thanks in advance

[dragoncity99]

It might be difficult if usign current timestamp. Probalby you need to convert it to time in terms of Epoch time since the number is incremental and sort-able.

Otherway is to remove the ":" and do sorting get the last ones.