Problems sorting a CSV with sort

Johnny Rosenberg gurus.knugum at gmail.com
Fri Aug 9 15:14:46 UTC 2013


2013/8/9 Tony Arnold <tony.arnold at manchester.ac.uk>:
> Johnny,
>
> Just played with csvtool.
>
> You could use it to replace the , field separators with TABs, say, pipe
> through sort specifying TAB as the field delimiter and then pipe through
> csvtool again to convert the fileds separators back to commas. E.g.:
>
> csvtool -t ',' -u TAB cat input.csv | sort -f 2 -t '    ' | csvtool -t TAB
> -u ',' cat - > output.csv
>
> Not tried the above so it may need adjusting, but I think you should get
> the idea.
>
> Regards,
> Tony.

Thanks! I'll take a closer look at that csvtool later. Looks promising
so far, at least.


Johnny Rosenberg




More information about the ubuntu-users mailing list