Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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: 1142
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 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%)
How to extract column 3,6,7,8 from each line of text? (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