CSV import with blanck fields

I am running libre office 24.2.7.2 on Ubuntu, Opening a CSV file, comma delimited. Most of the cells open just fine. However when I use file → open to open a document with a bunch of commas in a row; it treats it as one. If I add a space between them, it is fine. If I paste text and import it as CSV it uses the commas. It’s not urgent since I have two work arounds; but this does not seem to follow the CSV standard. Thanks, Jeff

There is a csv-IMPORT-DIALOG if you take a closer look on it, you will eventually recognize the Option [x]merge Delimitersuncheck…

1 Like