| User: editor -- 2008-05-15 << 109 111 >> |
| Hits: 541 |
| Type: Text merge |
| Search all Text merge examples |
| Description: |
| How to merge other columns' data base on the value of the first column? |
| Input Sample: |
| Tommy 123 456 Tommy 456 789 Mary 987 654 Susan 01 23 Susan 45 67 Susan 89 10 |
| Output Sample: |
| Tommy 123 456 456 789 Mary 987 654 Susan 01 23 45 67 89 10 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| This is a complicate case, just need to follow for beginner: 1.press ctrl-o to open source file 2.press ctrl-h to open replace dialog, set as follows: In 'Replace' page: * Set 'Replace Unit' to 'Line' * Fill 'Search for pattern': * Fill 'Replace with pattern': In 'Advanced' page: set 'run following for each matched unit' to: 3. click 'Replace' Button, ok |
| Download Script: scripts/110.rst.zip |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |