Problems sorting a CSV with sort

[Johnny Rosenberg]

2013/9/4 Johnny Rosenberg <gurus.knugum at gmail.com>

> 2013/8/9 Johnny Rosenberg <gurus.knugum at gmail.com>
>
>> 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
>>
>
> Have been playing around with it now. It seems to work but there is one
> downside: It doesn't seem to support pipes…
> SomeCommand | csvtool -t ',' -u TAB | sort…    # Not supported…?
>
> Well, I don't need to use pipes, but it would be more convenient. Now I
> need to create at least one temp file, which isn't a big problem, but
> still… One can always wish for more…
>
>
> Johnny Rosenberg
>
>
My bad. Some kind of a writing before thinking thing, I guess, sorry for
that. I just didn't notice that you actually piped csvtool in your example…
So I'm going to experiment more with this right now. It seems like it
actually does exactly what I want to do…


I was also searching for more information and found something called
”csvtools”. It seems to be some kind of collection of csv tools, such as
converters to and from csv and tsv (csv2tsv and tsv2csv). It isn't
available in the repositories, so I think I stick with csvtool for a while,
at least.

https://github.com/ceumicrodata/csvtools



Johnny Rosenberg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20130904/2e42cfba/attachment.html>