| User: John -- 2011-03-27 << 749 751 >> |
| Hits: 3238 |
| Type: Text file splitter |
| Search all Text file splitter examples |
| Description: |
| Compare two column in two files. If match, append two files. |
| Input Sample: |
| c:\a.txt column1 column2 ================ aaa 123 bbb 123 ccc 123 c:\b.txt column1 column2 ================ aaa 321 bbb 321 ccc 321 |
| Output Sample: |
| if column1 in both file matches, append column2 in file a into file b. c:\b.txt column1 column2 column3 ======================= aaa 123 321 bbb 123 321 ccc 123 321 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open b.txt 2. ctrl-h open 'replace' dialog * set 'replace with pattern' to: * set 'if' to: * click 'advanced' tab: * set 'Run following at the beginning of replace' to: 3. click 'Replace', done! 4. ctrl-s save to b.txt |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |