2 ms·
> To understand how awful it is, you just have to ask two questions Those are rookie questions. What about when the data contains newline/crlf? What if the dat
by magicalhippo 3y ago
> To understand how awful it is, you just have to ask two questions
Those are rookie questions. What about when the data contains newline/crlf? What if the data contains the quote character and newline?
And why is the file mostly Windows-1252 encoded except some fields that are sometimes, at random, UTF-8 encoded?
- kevindamm 3y agoStill basic questions. The real kicker is when your fellow users are opening the CSV in a spreadsheet with a locale that prefers commas for fractional currency amount and then saving the file back.