Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1434.Advanced search and replace -- How to rearrange columns of comma seperated file?

User: Dilip -- 2019-01-22          << 1433  1435 >>
Hits: 2836
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
In a comma seperated file rearrange entire columns 1,2,3,4,5 as  1,2,5,3,4
Input Sample:
1,2,3,4,5 
a,b,c,d,e
Output Sample:
1,2,5,3,4 
a,b,e,c,d
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open file 
2. ctrl-h open 'replace' dialog 
* set 'replace unit' to 'Line' 
* set 'replace with pattern' to: 
 
3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to replace the second column in a tab seperated file? (73%)
How to transpose(exchange row and column) a comma separated text file? (72%)
How to extract specified columns from a large pipe separated csv file? (63%)
How to attach column 8 to column2 except line 1 in a tab separated file? (62%)
How to re-arrange lines with in a specified number of lines? (61%)
How to replace certain column from different files?  (61%)
How to exchange column 2 and column 3 in multiple csv files? (61%)
How to change columns in each line to specified order in text file? (61%)

Check Demo of Advanced search and replace
Keywords:
seperate  range  columns  comma  ran  words  column  colu  colum  word  2 columns  replace comma  search words  match words  words to replace  replace words  words replace  replace 2 words