Hi All,
I have a text file with three columns. I would like a simple script that removes lines in which column 1 has duplicate entries, but use the largest value in column 3 to decide which one to keep. For example:
Input file:
12345a rerere.rerere len=23
11111c fsdfdf.dfsdfdsf len=33
22222a fds.fdsfdff.dsfdsf len=43
33333a ffffffffffff.ffff len=53
33333a ererfdggg.g len=55
33333a wewew.e len=23
44444a e.vv.ffffffffff len=22
Output file:
12345a rerere.rerere len=23
11111c fsdfdf.dfsdfdsf len=33
22222a fds.fdsfdff.dsfdsf len=43
33333a ererfdggg.g len=55
44444a e.vv.ffffffffff len=22
Any help is appreciated!