Pease see the picture
Anyone have an Idea of how to get from the sample text to this table:
a way might be to use the “text to columns” function in Calc as a middle way - But perhaps there is a smarter way to do it?
Pease see the picture
Anyone have an Idea of how to get from the sample text to this table:
a way might be to use the “text to columns” function in Calc as a middle way - But perhaps there is a smarter way to do it?
Like this:
Select the data that you want to convert.
Find/Replace (Ctrl+H)
In the Find box, type " +" (two spaces before +, don’t type the quotation marks)
In the Replace box, type “\t” (regexp for a tab character)
Tick More options, tick Regular expressions, click Replace all.
All multiple spaces have then be replaced by a tab character.
Select the data again, Table - Convert - Text to table, select tab key as separator character, done.
If this answer helped you, please accept it with (here on the left). That will help other people with the same question.
Thanks a lot
Wow! I was searching for that a lot! Thank you! It helpt me much! It may added as auto help tip when someone click onto “text to table” or, it must be added as an extra option: Use “all types of spaces” to make table from text. It will be very very convinient!
Thanks. Helped me.
Just to point this is using LO writer , this technique worked from me but I set regular expressions in the find-replace and bulk replaced \s with \t then Select the data again, Table - Convert - Text to table, select tab key as separator character, done.