3 ms·
Just an FYI, JSON and XML both have characters that need to be escaped properly.
by fxleach 5y ago
Just an FYI, JSON and XML both have characters that need to be escaped properly.
- cogman10 5y agoCorrect, and those methods of escaping are clearly defined in both specs. In CSV, there is no universal escaping system. It's all over the board. Any variable length text data format is going to run into issues when special characters are used in the data. CSV has no definition of what should happen when that occurs.
- fxleach 5y agoThe characters to escape are clearly defined in both specs, but that doesn't mean there's a universal escaping system. Just google "how to escape JSON" and you will see the wealth of users struggling to understand what and how to accomplish this. There will always be people struggling with escape characters, I don't see it being any harder or easier in any format.