Question
Export Data Store Entity to CSV - null/blank data in first column
Hi, My entity is a sql server view.
The first field is a nullable varchar.
When this field is null or a zero length string , it appears in the created file with double inverted commas and not blank.
All subsequent fields return nulls or zero length strings correctly as blanks
ie
""|value1|||value2
value3|value4|||value5
""|value6|||value7
If I create a UTF-8 csv file manually in excel with the first column as blank, it does not add double inverted commas, which is what I would expect
ie
|value1|||value2
value3|value4|||value5
|value6|||value7
Has anybody had a similar issue ?
Thanks
