Ask Your Question
0

Text to table....how???

asked 2015-03-25 19:42:10 +0100

califlefty gravatar image

updated 2015-03-25 19:44:24 +0100

what I have word, word, word, word word

what I want (single column)

word
word
word
word
word

thanks!!!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2015-03-25 20:42:47 +0100

JohnSUN gravatar image

updated 2015-03-25 20:44:14 +0100

Select this text (if needed)

Ctrl+H (or Edit - Find & Replace)

Search for [,]*[:blank:]*

Repkace with \n

Current selection only (if needed) and Regular expressions - On

And than Replace All

image description

edit flag offensive delete link more

Comments

ok, got it figured out thanks (works but not very elegant).

califlefty gravatar imagecaliflefty ( 2015-03-25 23:28:04 +0100 )edit

Hi - With same options you can also can search for \W\s* (also replace with \n)

Doc here

pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-03-26 10:01:36 +0100 )edit
0

answered 2015-03-25 21:48:12 +0100

califlefty gravatar image

updated 2015-03-25 23:29:36 +0100

OK thanks, got it figured out.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-03-25 19:42:10 +0100

Seen: 38 times

Last updated: Mar 25 '15