3 ms·
CSV is not really a standard, various programs have their own interpretation (even MS Excel allows a header line before the data that contain specifications for
by hnick 7y ago
CSV is not really a standard, various programs have their own interpretation (even MS Excel allows a header line before the data that contain specifications for the file, such as delimiter, which you probably won't account for in a home-grown solution).
So use a dedicated tool or library or you will run into trouble one day.
For one off jobs, I open it in Excel or similar and save as tab or pipe delimited text. This usually plays much more nicely with command line utilities, assuming it didn't mangle any numbers.