WebAPIContrib.Core
WebAPIContrib.Core copied to clipboard
Quotes are not escaped (CSV formatters)
Hi, For csv file needs double quotes to be escaped (by using another set of double quotes), because the double quote by itself denotes the boundaries of a field.
field 1,field 2,"field, with "escaped" quotes" -
is not correct!
field 1,field 2,"field, with ""escaped"" quotes" -
is сorrect
Here is a complete explanation including specific references to Excel handling: http://www.csvreader.com/csv_format.php
From Wikipedia: http://en.wikipedia.org/wiki/Comma-separated_values
Each of the embedded double-quote characters must be represented by a pair of double-quote characters.
1997, Ford, E350, "Super, ""luxurious"" truck"
@dmitriy-shleht Thanks for reporting. Will look into this, fix it, or add an optional configuration for this
Ok. In my spare time I will do it
https://github.com/WebApiContrib/WebAPIContrib.Core/pull/138