CSV Export from Grid is not usable when data contains commas

Suite and Optimus Suite 7
#1

Hello,

I raised this here without any reply, so just thought I’d raise this in the forum too.

Is there a way to improve CSV serialization? No “” are placed around values, so any values containing commas are parsed by other systems as out of place columns, it is unusable.

Why can’t EVERY value be surrounded by “” and then all "s inside the value be replaced with double quote?

That way this:
1, Tue, 21 May 2012, This is some text containing a " character

Becomes:
“1”, “Tue, 21 May 2012”, “This is some text containing a “” character”

See https://stackoverflow.com/questions/17808511/properly-escape-a-double-quote-in-csv/17808731#17808731

#2

I apologize for the delay with the reply.
Thank you for your report. The problem is confirmed. We’ll try to fix it in one of the future updates.

#3

We have fixed the grid CSV serialization in the latest dhx.Suite update (v. 7.3.1).
Now the values containing the commas are wrapped in the quotes.