Ask Your Question

I would like to import text file which has more than one space between values

asked 2015-07-22 15:12:20 +0200

lolax gravatar image

updated 2015-08-24 09:42:49 +0200

Alex Kemp gravatar image

LibreOffice 4.3.7

I used space as delimiter to separates values for the text file, but it generates a lot of blank cells, since Calc doesn't have the option "Treat Consecutive delimiters as one", therefore I need to use the "Fixed Width" to fulfill this requirement. Is there any way to solve this issue ? Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-07-22 15:17:13 +0200

Lupp gravatar image

updated 2015-07-22 15:17:42 +0200

Calc offers that option, but it is labelled 'Merge delimiters'.

edit flag offensive delete link more


It's working. Thanks.

lolax gravatar imagelolax ( 2015-07-22 15:34:13 +0200 )edit

BTW, MS Excel will tick the option "Treat Consecutive delimiters as one" automatically when selecting space as delimiter.

lolax gravatar imagelolax ( 2015-07-23 02:03:08 +0200 )edit

@lolax Thanks for the information!

In addition: Calc will use again the settings made for the last import if not expressly changed. For the equally structured 'Text to Columns...' tool the behaviour is the same, but independent of the csv import.

As far as I can remember discussions about feture requests concerning some tools also offering options this was the most favoured behaviour as compared with autonomous "smart" or "fix default" the software itself. I agree.

Lupp gravatar imageLupp ( 2015-07-23 11:24:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-07-22 15:12:20 +0200

Seen: 99 times

Last updated: Jul 22 '15