Data Manipulation

[scojopa]

I have a bit of data the text to columns feature is not working since the data is separated by different lengths of spaces.I have tried the text import wizard I cannot use spaces or comma since they are used within a company name. It puts all the data in column A

How can I do a find/replace w/ reg expression to insert a tab only where there are two or more consecutive spaces? Then I could to text to columns using the tab delimiter? Or is there a better way to just put data in a new column when there are 2 or more spaces?

Or if there is a better way to go about it. Appreciate the assistance.

[anon87010807]

See https://help.libreoffice.org/5.2/Common/List_of_Regular_Expressions for a list of regular expressions.

For you this would work: Search: [:space:]{2,}

Replace: \t

Tick Other options and make sure that Regular expressions is checked.

Replace all

That should do it.

[scojopa]

Thank you ,