Ask Your Question

Convert Text to table [closed]

asked 2016-11-20 07:17:52 +0200

T-buch gravatar image

Pease see the picture Anyone have an Idea of how to get from the sample text to this table:

image description

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-15 21:02:41.524381

1 Answer

Sort by » oldest newest most voted

answered 2016-11-20 10:31:27 +0200

floris v gravatar image

updated 2016-11-20 12:25:25 +0200

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.

edit flag offensive delete link more


Thanks a lot

T-buch gravatar imageT-buch ( 2016-11-20 11:40:21 +0200 )edit

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!

estatistics gravatar imageestatistics ( 2019-12-12 09:01:46 +0200 )edit

Thanks. Helped me.

Prasanna V gravatar imagePrasanna V ( 2020-10-14 06:46:59 +0200 )edit

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.

zzapper gravatar imagezzapper ( 2020-11-12 10:07:09 +0200 )edit

Question Tools

1 follower


Asked: 2016-11-20 07:17:52 +0200

Seen: 1,944 times

Last updated: Nov 20 '16