Page 1 of 1

Reverse of Join Lines

Posted: Fri Oct 17, 2008 10:14 am
by Jignesh
Is it possible to do the reverse of the Join Line function, found under the Edit menu.

For example,

A1
A2
A3
A4

Join line produces===>

A1 A2 A3 A4


I would like a procedure which does the reverse of this, is this possible?

I was thinking maybe something on the lines of using the replace function, ie replacing all spaces with 'Enter/Return' key but I dont know how to do this.

Many thanks
Jignesh

Posted: Fri Oct 17, 2008 12:02 pm
by ben_josephs
Replace the underscore with a space in:

Find what: _
Replace with: \n

[X] Regular expression

Replace All
Note: This doesn't use regular expressions, but you need to select the Regular expression option in order to get \n in the replacement expression interpreted as a newline.

Posted: Fri Oct 17, 2008 12:27 pm
by Jignesh
Brillaint that works a treat!