| User: editor -- 2011-09-16 << 855 857 >> |
| Hits: 3134 |
| Type: Text sort |
| Search all Text sort examples |
| Description: |
| How to sort a list of email addresses by the order of the domain name? |
| Input Sample: |
| aaa@hotmail.com 111@hotmail.com 222.999@yahoo.com 333@hotmail.com 000@hotmail.com 888@yahoo.com |
| Output Sample: |
| 000@hotmail.com 111@hotmail.com 333@hotmail.com aaa@hotmail.com 222.999@yahoo.com 888@yahoo.com |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open the source text file that contains email addresses 2. ctrl-h open 'replace' dialog * set 'replace with pattern' to: 3. click 'Settings' page, set Word Delimiter>>Input Delimiter to 'other', and enter at the following entry 4. click 'replace', done! Note: sort_by_word(text,'2,1') means sort the text by the order of the 2nd word, then 1st word, the word delimiter is configured at 'settings' tab. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Settings_Window |
Similar Examples: |
| How to sort all lines of ip addresses in a text file? (67%) How to sort the lines in a text files by the order of line length? (64%) How to extract all email addresses from many text files? (59%) How to add a port 80 for all IP addresses in a text file? (58%) How to sort numbers by the order of distance from some number? (57%) How to sort each line of text by the order of reversed line? (57%) How to sort the numbers in each line by the descending order in a text file? (56%) How to extract email addresses from multiple webpages? (56%) |
Check Demo of Text sort |
| Keywords: |
| figure email addresses 1st 2nd email address email email a mail addresses contains sort text file by domain name sort text file email addresses list email tab delimiter replace word contains contains word text sort open source open source text file sort |