Considerations for using quote characters, row and, column delimiters.
- Quotes can appear anywhere within a value.
- A file and each value must have an even number of quote characters.
- Quotes cannot be escaped.
- Delimiters (row or column) within quotes are treated as a part of the value.
- Quotes are always stripped from data values.
For a value 'abc,def', these examples are quoted correctly, and are read as one value:
"abc,def"
abc","def
"a"bc","d"e"f
abc",def"
"""abc,"def""""""
These examples are read as two values:
abc,def
""abc,def""
"abc",def
This example is read as an error: "'abc,def".