| User: editor -- 2011-12-26 << 898 900 >> |
| Hits: 4400 |
| Type: Text merge |
| Search all Text merge examples |
| Description: |
| How to merge two or more columns into one column in multiple csv files? How can I merge column B and column C of multiple csv files? |
| Input Sample: |
| A1,B1,C1,D1 A2,B2,C2,D2 A3,B3,C3,D3 |
| Output Sample: |
| A1,B1-C1,D1 A2,B2-C2,D2 A3,B3-C3,D3 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. open "Tools->Batch Runner" window 2. drag multiple csv files from Windows File Browser to "Batch Runner" window 3. click "Fast Replace" button. 4. click "Add" to add new * set "search" to: * set "replace" to: 5. check option of "regular exp" and uncheck option of "cross line" 6. click "Start", done. |
Screenshot 1: Fast_Replace_Window |