sort file based on certain criteria in line 1

[sco1104]

I have a problem with sort and uniq commands

I have a large file with the following format

06-02-2005 00:01:16|INFO |06-02-2005|00:02:06|481780134|0x49|N|010101010101010101010101010

I need to sort and remove duplicate lines based on the second date and time stamp (after INFO), the series of numbers and the hex code (0x49) only.

I have tried
sort -t, -u -k27,55 "filename" > "output filname"

but I am not getting the results expected. Would anyone have any ideas on how this can be performed?? Your help is appreciated. Thank you..

 

[vgersh99]

sort -t '|' -u -k4,6 "filename" > "output filname"

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[PHV]

sort -u -t'|' -k 3.7 -k 3,6 "filename" > "output filname"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sco1104]

Thanks for the help. The output file is just what I need.