3

I've got two columns of data I need to sort: the first column(A) needs to be sorted lexicographically and for any rows which then contain the same column A string, I need them to be sorted numerically according to what's in the second column(B).

I was thinking 'sort -f' , but that would make a '12' in column B come before a '2'.

Edit: Accidentally typed column in place of row.

6

Yes, using the -k option to define sort keys, and the n option to specify numerical sorts:

$ echo -e "a 13\nb 2\na 2" | sort -k1,1 -k2,2n
a 2
a 13
b 2
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.