User: editor -- 2011-12-08 << 893 895 >> |
Hits: 3646 |
Type: Replace text in multiple files |
Search all Replace text in multiple files examples |
Description: |
How to exchange column 2 and column 3 in multiple csv files? |
Input Sample: |
a1,a2,a3,a4 b1,b2,b3,b4 c1,c2,c3,c4 |
Output Sample: |
a1,a3,a2,a4 b1,b3,b2,b4 c1,c3,c2,c4 |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. open "Tools->Batch Runner" menu 2. drag multiple csv files from file browser to "Batch Runner" window 3. click "Fast Replace" button to open "Fast Replace" dialog 4. click "Add" to add new rules * set "Search" to: * set "replace" to: * click "ok"` 5. make sure "reg exp" option is selected, click "start", and click "Yes", done. |
Screenshot 1: Fast_Replace_Window |