Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

209.Advanced search and replace -- How to reorganize following ":" delimited data into columns?

User: editor -- 2008-07-02          << 208  210 >>
Hits: 1928
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to reorganize following ":" delimited data into columns?
Input Sample:
name:bill gates
age:55
gender:male
address:street 123
name:...
age:...
Output Sample:
name|age|gender|address
bill gates|55|male|street 123
...
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:


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

3. click 'Replace'. Finish.

Note: above operation is to seperate data by paragraphs, the start line of paragraph is indicated by "name:" field.
For each paragraph, take the 2,4,6,8 words and paste them side by side(The delimiter of words is not space, but the ':' or 'line break'):

word1(name):word2
word3(age):word4
word5(gender):word6
word7(address):word8

will changed to word2|word4|word6|word8
Download Script:  scripts/209.rst.zip

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Screenshot 3:  Replace_Settings_Window


Similar Examples:
How to batch reorganize following stock datas from CSV to TXT? (60%)
How to make following user defined format conversion? (58%)
How to remove all lines with duplicate value in column B in CSV file? (52%)
How to re-organize excel data with complicate date format? (52%)
How to convert database file into "|" delimitered file? (51%)
How to convert the data into a table with columns? (50%)
How to re-organize following text and generate a new format dictionary? (50%)
How to randomly remove comma delimited sentence fragments? (48%)

Check Demo of Advanced search and replace
Keywords:
delimited  paragraphs  seperate  field  line break  break  dic  non  paragraph  paragra  insert space at start of each line  paste text side by side  insert space line  insert at start of each line  insert space  space columns  insert end paragraph  paragraph end delimiter