Ask Your Question
0

Convert Text to table

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

floris v gravatar image

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

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

Comments

Thanks a lot

T-buch gravatar imageT-buch ( 2016-11-20 11:40:21 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 300 times

Last updated: Nov 20 '16