Hacker News new | ask | show | jobs
by nol13 2993 days ago
csvfix, prob some overlap, but i've found this one invaluable.

http://csvfix.byethost5.com/csvfix15/csvfix.html

2 comments

CSVFix author here - please note a better link is https://neilb.bitbucket.io/csvfix/
Sweet, 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.

Thanks 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.