Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

717.Advanced search and replace -- How to join every 20 emails into one group that delimitered by semicolon?

User: editor -- 2011-02-15          << 716  718 >>
Hits: 1816
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to join every 20 emails into one group that delimitered by semicolon? 
There are many email addresses, each one occupies a single line, how to join them into groups, each group has 20 emails that seperated by semicolon?
Input Sample:
email1@address1.com 
email2@address2.com 
... 
email100@address100.com 
Output Sample:
email1@address1.com;email2@address2.com;... email20@address20.com 
email21@address21.com;email22@address22.com;... email40@address40.com 
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open text file that contains email addresses 
2. ctrl-h open replace window 
* set 'search for pattern' to: 
 
* set 'unit number filter' to: 
(means numbers not equal to 20,40,60,...) 
* set 'replace with pattern' to a single semicolon: 
 
3. click 'replace', done! 
 
Note: the operation above means change the newline to semicolon if the line_no is not 20,40,60,80,...

Screenshot 1:  Replace_Window


Similar Examples:
How to join every n lines into 1 line in a text file? (56%)
How to convert database file into "|" delimitered file? (55%)
Join every 3 lines into one line (53%)
How to join every 3 lines into 3 columns of csv file? (50%)
How to batch split files into columns that separated by comma? (50%)
How to convert numbers into scientific format with specified spacing? (49%)
How to merge every two lines into one line between (part1) and (partn)?  (48%)
How to convert the data into a table with columns? (47%)

Check Demo of Advanced search and replace
Keywords:
emails  colon  not equal  groups  equal  seperate  newline  email addresses  email address  email  semicolon newline  equal number  filter email  join text to single line  replace semicolon  email line  contains numbers  search and replace email addresses