| User: park -- 2011-02-21 << 722 724 >> |
| Hits: 404 |
| Type: Text merge |
| Search all Text merge examples |
| Description: |
| How to extract the first column of text files from the first fold,then merge it with the same name files in the second fold?there are more than 3 files in each fold. |
| Input Sample: |
| C:\000009.TXT C:\000018.TXT C:\600022.TXT D:\000009.TXT D:\000018.TXT D:\600022.TXT C:\000009.TXT 2007/01/11,4.3965,4.3959,4.3896,4.4045 ,2359129.4815,4.4222 2007/01/12,4.4709,4.4312,4.4801,4.4381 ,2353854.7925,4.4381 2007/01/15,4.5775,4.4665,4.5835,4.4891 ,2347942.3665,4.4659 2007/01/16,4.5963,4.5018,4.58,4.5025,2 341265.2106,4.5028 D:\000009.TXT 3.43851,3.46645,3.44618,3.4771,2.46867 e+007,3.41567 3.3952,3.40142,3.38973,3.4044,2.46784e +007,3.38318 3.31738,3.33639,3.31763,3.3 |
| Output Sample: |
| D:\000009.TXT 2007/01/11,3.43851,3.46645,3.44618,3.4 771,2.46867e+007,3.41567 2007/01/12,3.3952,3.40142,3.38973,3.40 44,2.46784e+007,3.38318 2007/01/15,3.31738,3.33639,3.31763,3.3 2537,2.46703e+007,3.34063 2007/01/16,3.24996,3.27135,3.25454,3.2 594,2.46609e+007,3.29626 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| Firstly, extract the first column of all files in c:\, and put the result to d:\new 1. open "Tools->Batch Runner" window, drag files in c:\ to "Batch Runner" window 2. set "change output folder" to 3. click "Fast Replace" button * click "Add", set "search" to: * set "replace" to: * click "ok" * make sure "regular exp" option is selected. 4. click "start", new files will be generated in d:\new, with one column: d:\new\000009.txt 2007/01/11 2007/01/12 2007/01/15 ... Following steps read files in d:\ and merge them to d:\new 5. ctrl-h open 'replace' window * change the ">" to ">>> column append" between the "out page" and "output file" at the bottom of the window. * click "settings" page, set "output delimiter" to "other", and fill "," behind 6. click "Batch..." to open "Batch Runner" window 7. drag files in folder d:\ to "Batch Runner" window 8. set "change output folder" to "d:\new" 9. click "batch replace'. |
Screenshot 1: Batch_Runner_Window |