CSV Export from Grid is not usable when data contains commas


#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