Replace Pioneer Home   All Examples   Free Download

 New request --free

161.Advanced search and replace -- How to convert the data into a table with columns?

User: editor -- 2008-05-28
Hits: 395
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to convert the data into a table with columns?
Input Sample:
id 1
name Jack
gender Male

id 2
name Mary
gender Female

id 4
name Harry
gender Male

...
Output Sample:
id name gender
1 Jack Male
2 Mary Female
4 Harry Male
...
Answer:
Hint: You need to Download and install "Replace Pioneer" to finish following steps.
1. ctrl-o open your source file.
2. ctrl-h open 'Replace' dialog

in 'Replace' page:
* set 'Replace Unit' to paragraph
* set 'Search for pattern' to:

* set 'Replace with pattern' to:


click 'Advanced' page:
* set 'insert begin text' to:

or id\tname\tgender

click 'Settings' page:
* select 'Para start' to 'other', and set to ^NA at right.
* select 'Para end' to 'None'

3. click 'Replace'. Finish.
Download Script:
scripts/161.rst.zip
Check Demo of Advanced search and replace