Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

723.Text merge -- How to make column merge for files in two folders?

User: park -- 2011-02-21          << 722  724 >>
Hits: 2533
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


Screenshot 2:  Fast_Replace_Window


Screenshot 3:  Replace_Settings_Window


Similar Examples:
How to merge columns of 2 files with the same name in different folder? (63%)
How to move all the jpg files to its parent folder? (62%)
How to delete the 4th column from text files with 8 columns? (60%)
How to extract the 7th column from text files with 8 columns? (59%)
How to merge two files line by line? (58%)
How to split many merged avi files into original avi files? (57%)
How to copy a specific file to all sub-folders? (56%)
How to join hundreds of columns in different files into one csv file? (56%)

Check Demo of Text merge
Keywords:
column append  column merge  same name  more than  folders  200  bottom  text merge  merge  merg  read from one column replace from second batch file  batch extract merge column  extract and merge  extract first column batch  extract first column  batch replace text between two  merge text files with same name  batch file text extract column