4 ms·

Yes, that's how they're supposed to be. Any field with quotes, or commas, or newlines in the data needs to have quotes around it. Any quotes in the data need to

Yes, that's how they're supposed to be. Any field with quotes, or commas, or newlines in the data needs to have quotes around it. Any quotes in the data need to be escaped by preceding them with another quote.

justinator 13y ago
From what I understand, you're basically right, but you're basically right only in a sense that that's what most people do. There's no "CSV Data Format" spec. It's all just what most people agree on, most of the time. Unless someone has another idea.
- steveklabnik 13y ago
  text/csv is defined in RFC 4180: https://tools.ietf.org/html/rfc4180 https://tools.ietf.org/html/rfc4180
  - nemetroid 13y ago
    Strictly, the definition in RFC 4180 mandates ASCII which makes it unusable for many purposes. I guess there's nothing practical stopping you from using another encoding though.
    - steveklabnik 13y ago
      > Common usage of CSV is US-ASCII, but other character sets defined > by IANA for the "text" tree may be used in conjunction with the > "charset" parameter. http://www.rfc-editor.org/rfc/rfc6657.txt http://www.rfc-editor.org/rfc/rfc6657.txt https://www.iana.org/assignments/character-sets/character-sets.xhtml https://www.iana.org/assignments/character-sets/character-se...