User: editor -- 2008-05-15 << 109 111 >> |
Hits: 3862 |
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 |