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
-
Team emacs! However I'm intrigued. I spot this bit of advice https://stackoverflow.com/a/20721203 and found this plugin https://vimawesome.com/plugin/csv-vim were those close to what you were thinking?
Yeah there’s things like that, but vim basically embeds sed and awk in an editor with quick macro redo so doing initial cleaning of csv is easy. Also there’s https://github.com/BurntSushi/xsv/blob/master/README.md …
-
-
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.
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.