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

 

  Discussion posts and replies are publicly visible