I have a file with entries like the following:
female,9,13,6.3152956461 female,12,12,5.4797699786 female,11,11,3.6421699174 female,9,14,4.5933365997 female,8,14,2.4181574607
I first want to remove all but the first 2 columns, then separate them by a space instead of a comma. Ultimately though my problem is that I need to sort by column 1, then column 2 but I have to keep the pairing in a given row intact.
I believe that I need to use sed to switch the column deliminator and sort to do the sorting but I can't figure out how to keep the row pairings together between the 2 sorts.