bug in CSV output
Posted: Mon Dec 07, 2015 6:19 pmThere's a bug in the CSV output format for some strings (though admittedly odd, we need our software to be robust).
The original string is:
"XX Promo 1234p 14.1"" 2GB/120GB Rmkt PC
And DBeaver outputs it verbatim in the CSV file as a field. If you try to parse this with Excel or anything, it'll take the initial double quotes as the beginning of a quoted field, strip those quotes, then get confused as it processes the rest. Excel and OpenCSV ended up gobbling multiple lines due to this format error.
Thanks in advance for fixing this someday.
-G
Retested in version 3.5.5. Still there. Used default CSV export settings.
The original string is:
"XX Promo 1234p 14.1"" 2GB/120GB Rmkt PC
And DBeaver outputs it verbatim in the CSV file as a field. If you try to parse this with Excel or anything, it'll take the initial double quotes as the beginning of a quoted field, strip those quotes, then get confused as it processes the rest. Excel and OpenCSV ended up gobbling multiple lines due to this format error.
Thanks in advance for fixing this someday.
-G
Retested in version 3.5.5. Still there. Used default CSV export settings.