4 ms·
csvfix, prob some overlap, but i've found this one invaluable. http://csvfix.byethost5.com/csvfix15/csvfix.html http://csvfix.byethost5.com/csvfix15/csvfix.htm
by nol13 8y ago
csvfix, prob some overlap, but i've found this one invaluable.
http://csvfix.byethost5.com/csvfix15/csvfix.html http://csvfix.byethost5.com/csvfix15/csvfix.html
- forinti 8y agoThanks for this link! I frequently have to load CSV files into a database and they are invariably full of errors. People think spitting out CSV is easy, but it's because they don't have to use their product. So every time I write a Perl script and go through various iterations before I find all that's wrong with the file.
- zabzonk 8y agoCSVFix author here - please note a better link is https://neilb.bitbucket.io/csvfix/ https://neilb.bitbucket.io/csvfix/
- nol13 8y agoSweet, ty! Staring at what was starting to look like a much larger python script than I'd anticipated, then realizing I could do it in 16 lines of (very basic) bash with csvfix + csvcut/sed/iconv was big day for me! Some of my fav code never written I think. Actually had most those files copied locally because was afraid the bytehost link would disappear. That said, link to the manual in the bitbucket link not working.