| User: John -- 2011-03-27 << 750 752 >> |
| Hits: 3216 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to batch append the columns of file A and B if third column are identical? There are a1...n.txt in folder c:\file1 There are a1...n.txt in folder c:\file2 Compare a1..n.txt in both folders, if column3 is matched in both text file, append c:\file2\a1.txt into c:\file1\a1.txt batch run for each txt in the folder |
| Input Sample: |
| c:\file1\a1.txt col1 col2 col3 col4 --------------------------------- 1. ### bin3 100 2. *** soeng3 200 3. &&& gung1 300 c:\file2\a1.txt col1 col2 col3 col4 col5 -------------------------------------- 1. ### bin3 bin 3 2. *** soeng3 soeng 3 3. &&& gung1 gung 1 |
| Output Sample: |
| c:\output\a1.txt col1 col2 col3 col4 col5 col6 -------------------------------------- 1. ### bin3 100 bin 3 2. *** soeng3 200 soeng 3 3. &&& gung1 300 gung 1 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. 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: 2. click 'Batch...' button to open 'Batch Runner' window * drag files a1...n.txt from foler c:\file1 to 'Batch Runner' window * check option of 'Change output folder', and set the following entry to: 3. click 'Batch Replace' button, done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |