Apache OpenOffice (AOO) Bugzilla – Issue 116919
Calc import CSV ignores text delimiter
Last modified: 2011-02-11 09:16:22 UTC
My CSV file looks like this... Number, Color, Letter, Sequence, Direction One, Red, , , Up Two, Blue, , , Down Three, Green, Alpha, "A, B, C", West On import, column delimiter is set to "Comma" and the "Text delimiter" field is set to double quotes. Note the fourth column in the third row: it's a quoted comma-delimited list. Calc is importing each element in the list as a separate column rather than importing them all together as a single text value. In addition, it's placing the first double-quote in the same cell as "A" and the second double-quote in the cell with "C". Calc should import the text "A, B, C" as a single cell without double-quotes. It's clearly ignoring the text delimiter. I'll attach screenshots of the import dialog and the resulting CSV in case the above description isn't clear.
Created attachment 75813 [details] Import CSV screen
Created attachment 75814 [details] Imported CSV with text delimiter ignored
The problem is the space after the comma, see issue 113421. *** This issue has been marked as a duplicate of 113421 ***
closing duplicate