Is there a bug with empty commas for csv import?

[taqmobile]

If I have a csv file with the following data

"col1","col2","col3","col4","col5","col6","col7","col8"
"x","x","x","x","x","x","x","x"

libre calc imports it fine

But If I have empty commas, it breaks. The preview for import looks ok but when it actually processes, it basically takes all following data and places it into the column before the commas. 4 of the commas are removed and the data just has the remaining commas and ALL other data in the column now.

"col1","col2","col3","col4","col5","col6","col7","col8"
"x","x",,,,,,"x"

See video:

2014-11-06_1001

The video pretty much confirms the issue

I can work around it by added empty quotes “” instead of nothing. Perhaps libre calc just doesn’t support empty commas the same way excel does?

[Lupp]

I cannot reproduce the results you describe. But the guy who made the “video” should not expect sensible results having set the comma as a column delimiter and as the text delimiter as well. In his case the funny thing is what he claims to get as preview.

[taqmobile]

I don’t follow. Of course text will have commas… they should be escaped if they are within quotes. The simple fact that the “preview” shows it correctly, but the finished data shows it wrong is proof enough of the bug.

[Lupp]

Did you notice that the comma was checked as ‘Text delimiter’ and among the column delimiters, too, in the import dialog in the video? No doublequotes visible. How to processs that?