Re:Client libraries are better when they have no API
by kevindamm on Thursday April 11, 2024 @02:29PM
(#40005272)
Still 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.
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?