Open ylupien opened 1 year ago
Do you want to open a PR for that? Also I'm pretty sure that programs like Excel will not work this way. Some scripting languages may "support" backslash escaping in CSV due to it being implemented in the core of string processing, but that's not the expected behavior when working with spreadsheet software.
file.csv
If you read the file
The current returned value of field
ok
is (Double back slashe and quote at the end):But it should be more like that :
Using PHP I tried to write and read that specific value using internal csv functions:
The output file is file.csv
And the value I received retrieve is:
Possible solution
As I know different way to encode quotes in csv value. One is using a escape string
\
Then encoding
Then resulting csv value look like that
If we don't use escape by default quote are doubled.
Maybe you can add an option escape: '\'