Re:Working with CSV files on shell/terminal
by kippinitreal on Tuesday June 27, 2023 @11:18PM
(#36501844)
Cool stuff! But it’s criminal to not call attention to JQ’s elder sibling CSVKit. It’s invaluable for playing with csvs. Much easier to parse out columns, allows you to generate new csvs and even merge them. More importantly, it allows SQL on csvs (via SQLite iirc) which empowers all sorts of csv shenanigans. The bash scripting this enables us incredible (good and bad).
Re:Working with CSV files on shell/terminal
by dgsb on Wednesday June 28, 2023 @03:08AM
(#36503310)
I agree it's indeed one of the best tool to process csv files. Using basic coreutils command are going to be soon very limited and brittle to process csv files.
https://csvkit.readthedocs.io/en/latest/