News for hackers. Stuff that matters.
Re:Client libraries are better when they have no API by magicalhippo on Wednesday April 10, 2024 @04:02PM (#39995127)
> 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?

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.