I have been trying to figure out on how to sort through a log file (format pasted below) using linux commands for sometime and I just can't get it to work. The file has a setup as follows;
columnA | colB | colC | colD name_1| data | 1 | data name_1| data | 2 | data name_1| data | 3 | data name_2| data | 1 | data name_2| data | 2 | data
I would like to have a file of only one entry of each name in columnA based on the highest value in column C with the corresponding data from the other columns at the row with highest value in colC.
If anyone knows any commands or pipes that would be greatly appreciated.