CSV Quoting
CSV quoting wraps field values that contain delimiters, quotes, or line breaks in double quotes so special characters can be embedded safely.
Purpose
To let CSV fields contain delimiters, quotes, line breaks, and other special characters without breaking parsing.
Mechanism
A field containing special characters is wrapped in "; a " inside a field is escaped by doubling it as "". Quoting strategies: QUOTE_MINIMAL (only when necessary), QUOTE_ALL, QUOTE_NONNUMERIC, QUOTE_NONE.
Use cases
- Text fields containing commas
- Multiline CSV fields
- Quote escaping