Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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

User: editor -- 2008-05-28          << 160  162 >>
Hits: 943
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" on windows platform 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 ^id at right.
* select 'Para end' to 'None'

3. click 'Replace'. Finish.
Download Script:  scripts/161.rst.zip

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Screenshot 3:  Replace_Settings_Window


Similar Examples:
How to convert the daily data into a weekly data with program? (67%)
How to convert the daily data into a weekly data in many text files? (60%)
How to convert a text file to specified format? (58%)
How to convert text with pig latin rules? (58%)
How to convert database file into "|" delimitered file? (57%)
How to convert binary data in many text file to hexdecimal data? (57%)
How to convert columns of data into SQL statement for mysql database? (56%)
How to convert each line of a text file to the new format? (56%)

Check Demo of Advanced search and replace
Keywords:
convert the data into a table with columns  table  paragraph  columns  insert begin text  insert begin  settings  setting  para  insert  insert end paragraph  insert data  paragraph pattern  search paragraph  paragraph replace  replace paragraph  insert end text  insert text end text