Today I continue exploring options to consider for splitting a single csv into multiple files based on a column value... A) awk/gawk B) use xsv or import to SQLite, sql query C) manually copy/paste
-
I have used xsv quite a bit, I like it. I also like that it’s written in Rust.
Also, https://csvkit.readthedocs.io/en/latest/ which has a funky SQL query feature, and https://github.com/aotimme/gocsv which seems to have more than xsv and if you like Java https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool … But, in vim I'm usually doing sorts and blasting fixes before using xsv or python.