Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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: 1404
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 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%)
How to delete the second column in multiple text files? (55%)

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