|User: editor -- 2013-04-26 << 1073 1075 >>|
|Type: Advanced search and replace|
|Search all Advanced search and replace examples|
|How to exchange row and column in a comma separated text file( or csv file)?|
|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
|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
|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|