linux Sort Unique by Column
Posted on 2013-06-04
Linux 2.6.18-308.11.1.el5 #1 SMP Fri Jun 15 15:41:53 EDT 2012 x86_64 GNU/Linux
I need to sort a file and eliminate duplicates based on the first column of a text file.
The text file looks like this (partial):
What I want the output to be after the sort is:
--essentially eliminating duplicate rows based only on the first column as delimited by "~".
I have tried various combinations of sort, but I am unable to get it to work.
Any help will be much appreciated!