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: 2850
Type: Advanced search and replace   
Search all Advanced search and replace examples
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
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/

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 csv files into tables with html format? (66%)
How to convert a duration of seconds to a time format? (60%)
How to convert the daily data into a weekly data in many text files? (60%)
How to count the number of non-empty columns? (58%)
How to join every 3 lines into 3 columns of csv file? (58%)
How to convert a text file to specified format? (58%)
How to convert text with pig latin rules? (58%)

Check Demo of Advanced search and replace
convert the data into a table with columns  table  non  paragraph  paragra  columns  insert begin text  insert begin  settings  setting  table to paragraph  insert end paragraph  insert paragraph  insert data  insert name  insert start  text to columns open source  search paragraph