Replace Pioneer Home All Examples Free Download

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