Replace Pioneer Home All Examples Free Download

1074.Advanced search and replace -- How to transpose(exchange row and column) a comma separated text file?

User: editor -- 2013-04-26 << 1073 1075 >>

Hits: 3654

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

How to exchange row and column in a comma separated text file( or csv file)?

Input Sample:

a1,a2,a3,a4
b1,b2,b3,b4
c1,c2,c3,c4

Output Sample:

a1,b1,c1
a2,b2,c2
a3,b3,c3
a4,b4,c4

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open text or csv file
2. ctrl-h open 'replace' dialogue
* set 'replace with pattern' to:

3. click 'replace', done.
4. ctrl-s save to file.
5. for multiple files, click 'batch...' in step 3, and drag multiple files to 'batch runner' window, and click 'batch replace' button, done.

Screenshot 1: Replace_Window

Similar Examples:

How to rearrange columns of comma seperated file? (72%)
How to replace the second column in a tab seperated file? (62%)
How to extract specified columns from a large pipe separated csv file? (60%)
How to extract the second column from a database text file? (60%)
How to change columns in each line to specified order in text file? (58%)
How to remove/delete all commas from comma separated numbers in a text file (58%)
How to attach column 8 to column2 except line 1 in a tab separated file? (57%)
How to change the direction of all sentences in a text file? (56%)

Check Demo of Advanced search and replace

Keywords:

exchange transpose trans separate comma csv para ran step row exchange column replace column exchange exchange row column exchange replace search for text in multiple csv files csv row replace with csv files multiple search and replace text in csv files