Sorting a CSV file from greatest to least based a number appearing in a column

5k views Asked by At

I have a CSV file like this:

bear,1
fish,20
tiger,4

I need to sort it from greatest to least number, based on what is found in the second column, e.g.:

fish,20
tiger,4
bear,1

How can the file be sorted in this way?

1

There are 1 answers

2
Brian Agnew On BEST ANSWER
sort -t, -k+2 -n -r filename

will do what you want.

-t, specifies the field separator to be a comma

-k+2 specifies the field to sort on (field2)

-r specifies a reverse sort

-n specifies a numeric sort