Replace Pioneer Home All Examples Free Download

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: 153

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 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%)
How to extract all c++ comments from multiple cpp files? (62%)

Check Demo of Replace text in multiple files

Keywords:

exchange column exchange rules csv fast replace fas fast row words replace text in multiple files exchange replace replace text multiple file rules replace multiple csv multiple rules replace multiple rules multiple rules replace csv from text replace rules