Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

894.Replace text in multiple files -- How to exchange column 2 and column 3 in multiple csv files?

User: editor -- 2011-12-08          << 893  895 >>
Hits: 1618
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


Similar Examples:
How to merge more columns into one column in multiple csv files? (79%)
How to add filename as a new column for multiple csv/txt files? (65%)
How to change letters in Column1 and Column4 to upper case? (64%)
How to extract and remove common lines from multiple files? (64%)
How to delete all lines with column B greater than 90 in multiple csv files? (64%)
How to change all bold tag to bold-italic tag in multiple html files? (64%)
How to batch change format of multiple files? (64%)
How to delete the second column in multiple text files? (63%)

Check Demo of Replace text in multiple files
Keywords:
exchange column  exchange  csv files  rules  csv  rule  fast replace  fast  fas  rows  replace column exchange  exchange replace  add text in multiple csv file  replace text in multiple csv files  replace text in multiple files csv  multiple replace in text file csv  text file multiple replace csv  replace multiple text csv