Replace Pioneer Home All Examples Free Download

1336.Advanced search and replace -- How to attach column 8 to column2 except line 1 in a tab separated file?

User: Dilip -- 2016-01-13 << 1335 1337 >>

Hits: 2602

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

In a tab seperated CSV file merge the contents of column 8 with contents of
coulmnn 2 preceded by one space except line no.1

Input Sample:

sno type text text text text text diet
1 dog text text text text text food

Output Sample:

sno type text text text text text diet
1 dog food text text text text text food

Answer:

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

1. ctrl-o open csv file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'unit number filter' to
* set 'replace with pattern' to:

3. click 'replace', done.

Screenshot 1: Replace_Window

Similar Examples:

How to rearrange columns of comma seperated file? (62%)
How to replace the second column in a tab seperated file? (59%)
How to remove duplicate words within column 1 in tab
separated file? (58%)
How to exchange column 2 and column 3 in multiple csv files? (57%)
How to extract the forth column in the second line from different files? (56%)
How to transpose(exchange row and column) a comma separated text file? (55%)
How to add a column which is the summary of column 3,4 and 6 in text file? (55%)
How to change columns in each line to specified order in text file? (54%)

Check Demo of Advanced search and replace

Keywords:

seperate contents except merge file merge merg mer separate unit number filter number filter words to replace preceded merge 2 csv search csv merge merge csv merge by column replace space with tab replace tab with space merge file line by line