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

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