Sort CSV file by multiple columns using the “sort” command

by

You need to use two options for the sort command:

  • --field-separator (or -t)
  • --key=<start,end> (or -k), to specify the sort key, i.e. which range of columns (start through end index) to sort by. Since you want to sort on 3 columns, you’ll need to specify -k 3 times, for columns 2,2, 1,1, and 3,3.

To put it all together,

sort -t ';' -k 2,2 -k 1,1 -k 3,3

Note that sort can’t handle the situation in which fields contain the separator, even if it’s escaped or quoted.

Also note: this is an old question, which belongs on UNIX.SE, and was also asked there a year later.

Old answer: depending on your system’s version of sort, the following might also work:

sort --field-separator=";" --key=2,1,3

Or, you might get “stray character in field spec”.

According to the sort manual, if you don’t specify the end column of the sort key, it defaults to the end of the line.

More Related Contents:

  1. Sorting a tab delimited file
  2. Csv empty when trying to read it
  3. What’s the most robust way to efficiently parse CSV using awk?
  4. Dealing with commas in a CSV file
  5. Properly escape a double quote in CSV
  6. Is there a way to include commas in CSV columns without breaking the formatting?
  7. sort csv by column
  8. How to load jar dependenices in IPython Notebook
  9. Sorting multiple keys with Unix sort
  10. csv to array in d3.js
  11. How to properly escape a double quote in CSV?
  12. Can you encode CR/LF in into CSV files?
  13. What MIME type should I use for CSV?
  14. Encoding Error in Panda read_csv [duplicate]
  15. Spark dataframe save in single file on hdfs location [duplicate]
  16. Is there a way to ignore header lines in a UNIX sort?
  17. How to split CSV files as per number of rows specified?
  18. Extract specific columns from delimited file using Awk
  19. What is the general syntax of a Unix shell command?
  20. Reading csv files with quoted fields containing embedded commas
  21. Parse a csv using awk and ignoring commas inside a field
  22. VBScript to loop through all files in a folder
  23. How to check encoding of a CSV file
  24. Parsing XML using unix terminal
  25. Isolate comma-separated values, remove duplicates and empty values, then sort
  26. Unix sort of version numbers
  27. Export as csv in beeline hive
  28. Why doesn’t **sort** sort the same on every machine?
  29. CodedUI test does not read data from CSV input file
  30. Import CSV into google cloud datastore

Leave a Comment