Re:Cheating at a company group activity using Unix tools
by devenvdev on Monday December 13, 2021 @09:20AM
(#29539764)
Most likely because it contradicts most people's experience, some CSVs can't be parsed with cli tools, but most of them can be, and it's much easier than writing code that does the same. So what the parent commenter says is true, just not pragmatic.
Re:Cheating at a company group activity using Unix tools
by oblio on Monday December 13, 2021 @10:35AM
(#29540490)
It is pragmatic with a minor tweak.
https://csvkit.readthedocs.io/en/latest/
https://github.com/BurntSushi/xsv
Heck, even sqlite has some stuff to help with processing CSV files: https://www.sqlite.org/csv.html
Re:Cheating at a company group activity using Unix tools
by philwelch on Tuesday December 14, 2021 @04:59AM
(#29550006)
csvkit and SQLite were always too slow whenever I tried to use them for this sort of thing. I don’t remember if I tried xsv. I do think I ended up converting most of my CSVs to TSV, or exporting them as TSV in the first place.
Parsing CSV with simple text-oriented tools is bad of an idea as parsing HTML with regexps.