CSV Escaping
CSV escaping handles delimiters, quotes, and line breaks inside field values, using quoting and doubled quotes so fields parse safely.
Purpose
To ensure special characters inside field values are not misparsed as CSV structural characters.
Mechanism
A field containing a delimiter, quote, or line break is wrapped in quotes; a quote inside a field is escaped by doubling it as "" (RFC 4180); some non-standard dialects escape with a backslash instead.
Use cases
- Exporting data with special characters
- CSV generation
- Safe data exchange