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
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 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
Keywords:
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