4 ms·
Isn't that your parser's problem? I don't think true CSV has any special characters other than comma, quote, and CRLF.
by Dylan16807 4y ago
Isn't that your parser's problem? I don't think true CSV has any special characters other than comma, quote, and CRLF.
- fy20 4y agoHow do I name my child CRLF?
- dylan604 4y agoearn Musk money, you can name your child WTF you want
- asdfghjkuytrf 4y agoi think you failed to parse the technical joke
- dylan604 4y agono, i totally got the line ending joke. i'm not an ID10T
- dylan604 4y agoI thought it strange too. I saw what the issue was, and just "fixed" it be correcting the data in the CSV. For the lulz, I guess I could have played with the parser's options on deciding what is needed to be escaped. However, the data would have still been incorrect as the '\' is definitely not part of the desired content, so ultimately it was better to correct the input. i would kind of rather the import die than having the potential foot gun of '\' in a field for later sabotage.
- dagw 4y agoUnless it's a CSV file exported from a Nordic locale Excel, in which case your CSV exports will use semi-colon as column separators and commas as decimal points. And yes the filename will still end with ".csv" So the following Excel export I just did will parse perfect fine with your CSV parser but give you completely the wrong thing: 1;2,3;3,3 2;7,3;9,3 3;4,5;7,5
- Tijdreiziger 4y agoThat has nothing to do with the Nordics, but with the decimal separator. In locales that use a comma as the decimal separator (i.e., most European locales), Excel uses a semicolon as CSV separator.
- Someone 4y agoThere is no “true CSV”. https://en.wikipedia.org/wiki/Comma-separated_values https://en.wikipedia.org/wiki/Comma-separated_values: “The CSV file format is not fully standardized. Separating fields with commas is the foundation, but commas in the data or embedded line breaks have to be handled specially. Some implementations disallow such content while others surround the field with quotation marks, which yet again creates the need for escaping if quotation marks are present in the data. The term "CSV" also denotes several closely-related delimiter-separated formats that use other field delimiters such as semicolons.[2] These include tab-separated values and space-separated values. A delimiter guaranteed not to be part of the data greatly simplifies parsing. Alternative delimiter-separated files are often given a ".csv" extension despite the use of a non-comma field separator. This loose terminology can cause problems in data exchange. Many applications that accept CSV files have options to select the delimiter character and the quotation character. Semicolons are often used instead of commas in many European locales in order to use the comma as the decimal separator and, possibly, the period as a decimal grouping character.” https://en.wikipedia.org/wiki/Comma-separated_values#Standardization https://en.wikipedia.org/wiki/Comma-separated_values#Standar... mentions a few standards for csv, one of which is the MIME type text/csv, standardized in RFC 4180.
- Dylan16807 4y agoI think it's valid to argue that you shouldn't be able to put some of commas, quotes, and newlines inside fields at all. And comma versus semicolon. But that doesn't extend to using backslash escapes in something that's legitimately trying to be CSV. That's someone getting confused and implementing a mix of data formats, or trying to be clever and making an extended CSV format.
- Someone 4y agoIt’s valid to argue that, but that means you can’t use CSV for many real-world data sets. That, in turn, means you almost cannot use CSV in any robust solution. Even if, today, your input doesn’t have commas, quotes or newlines, can you guarantee it won’t tomorrow, next year, etc?