| User: editor -- 2011-02-15 << 716 718 >> |
| Hits: 269 |
| 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 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%) How to count the number of words that started with "en"? (46%) |
Check Demo of Advanced search and replace |
| Keywords: |
| colon emails seperate groups newline email addresses email address email a email mail semicolon newline filter email email line search and replace email addresses replace newline replace with a group change the number for each join if line |