Ask Your Question

Import matrx of data and treat more than one seperator as one

asked 2015-10-21 11:40:27 +0100

luzuokun gravatar image

Hello, How can I treat more than one seperator as one? The seperator is "space" and the number of it is not the same, when I import the date, I cannot get aligned data? Thanks!

edit retag flag offensive close merge delete


How do you "import"?

Regina gravatar imageRegina ( 2015-10-21 21:08:44 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-11-10 15:45:54 +0100

LibreOffice 5.1 Calc answer.

Supposing you are importing a .txt file with a variable number of spaces between numbers (sometimes just 1, other times 2, 3, 4...)

Use File > Open... to open the txt.

In the import dialog, under Separator Options, select Separated by, uncheck all the separators except Space.

Check Merge delimiters.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-10-21 11:40:27 +0100

Seen: 73 times

Last updated: Nov 10 '16