Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1433.Advanced search and replace -- How to replace specific column with specific rule in csv file?

User: Dilip -- 2019-01-15          << 1432  1434 >>
Hits: 1239
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
In a tab seperated csv file replace 9th column that does not start with a leading space with prefix fixit
Input Sample:
1 2 3 4 5 6 7 8  dex 
1 2 3 4 5 6 7 8 dim 
1 2 3 4 5 6 7 8  dim 
1 2 3 4 5 6 7 8 dex 
Output Sample:
1 2 3 4 5 6 7 8  dex 
1 2 3 4 5 6 7 8 fixitdim 
1 2 3 4 5 6 7 8  dim 
1 2 3 4 5 6 7 8 fixitdex 
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' dialog 
* set 'replace unit' to 'Chars' 
* set 'replace scope' to 'Line' 
* set 'unit number' to  
* set 'search' to: 
 
* set 'replace' to: 
 
3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to delete line with specific columns in specific range? (71%)
How do I replace specified lines with each line from a file? (69%)
How to replace the second column in a tab seperated file? (68%)
How to replace the certain column with specified words? (68%)
How to extract specified columns from a large pipe separated csv file? (67%)
How to replace certain column from different files?  (66%)
How to replace specific spaces into comma in each line of text file? (65%)
How to search and replace words in specified column in csv file? (64%)

Check Demo of Advanced search and replace
Keywords:
leading space  prefix  seperate  leading  specific  fix  space  csv  not start with  replace scope  search and replace prefix  replace tab with space  replace space with tab  replace with specific  search and replace column in a csv file  column search and replace in csv  start with number  replace number column