Why is LibreOffice CALC having problem with text delimited files

asked 2017-08-04 21:14:12 +0200

Chuck47 gravatar image

have text delimited file (pipe symbol = |) however when I click on file and open with LibreOffice Calc, then I have text import box, click other and show pipe symbol, and click OK (nothing else checked), Instead of getting multiple rows, the first 8 or 9 lines are all in a single row, then remainder of file is fine. It is better than 5.3 which could not handle any of the pipe symbol delimited text. Any ideas on what is wrong?

edit retag flag offensive close merge delete


Are you sure such rows a correctly formatted?, maybe not the right Character Set selected.

m.a.riosv gravatar imagem.a.riosv ( 2017-08-04 22:58:39 +0200 )edit

I do a little bit with CSV files from my flip phone. I just imported one and I had to make sure that only the comma delimiter was selected. Did you make sure that only the pipe symbol was selected?

Also, some CSV files have headings or other special information in the first few rows,so they might require slightly different handling than the rest of the file. This is why @m.a.riosv's suggestion is the first thing to check.

josephj11 gravatar imagejosephj11 ( 2017-08-06 14:47:22 +0200 )edit

Since a normal CSV file is plain, line-delimited text, It should be easy to examine using a text editor (not a word processor - something like notepad in Windows or kate in Linux).

josephj11 gravatar imagejosephj11 ( 2017-08-06 14:49:40 +0200 )edit