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 |