Import matrix of data and treat more than one separator as one

[luzuokun]

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!

[Regina]

How do you “import”?

[asiersar]

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.