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