3 ms·
As soon as you encounter any CSVs where field values may contain double quotes, commas, or newlines, you need tooling to work with CSV as well. (TSV FTW)
by re 1y ago
As soon as you encounter any CSVs where field values may contain double quotes, commas, or newlines, you need tooling to work with CSV as well.
(TSV FTW)
- spicybbq 1y agoOne of my first tasks as a junior dev was replacing an incorrect/incomplete "roll your own" CSV parsing regex (which broke in production) with a library.
- IAmBroom 1y agoTSV is superior to CSVs, and it still angers me that Excel doesn't offer it as a standard input option, but your examples are fairly easily handled by eye in a text file. Tools definitely make it faster and more reliable.
- euroderf 1y agoASCII FS GS RS US ... just make decent font entries for them.