Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1335.Advanced search and replace -- How to replace the second column in a tab seperated file?

User: Dilip -- 2016-01-13          << 1334  1336 >>
Hits: 1671
Type: Advanced search and replace   
Search all Advanced search and replace examples
In a tab separated text file find words in the second column and replace withe  
new text in one step
Input Sample:
1 shoe 
2 bag 
3 shirt 
4 t-shirt 
Output Sample:
1 shoes 
2 bags 
3 top 
4 polo
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open text file 
2. ctrl-h open 'replace' dialogue 
* set 'replace unit' to 'Word' 
* set 'replace scope' to 'Line' 
* set 'unit number filter' to  
* set 'replace with pattern' to the content you need 
3. click 'replace', done.

Screenshot 1:  Replace_Window

Similar Examples:
How to extract the second column from a database text file? (78%)
How to rearrange columns of comma seperated file? (73%)
How to delete the second column in multiple text files? (70%)
How to remove duplicate words within col 1 in tab separated file? (69%)
How to replace specific column with specific rule in csv file? (68%)
How to extract specified columns from a large pipe separated csv file? (68%)
How to replace certain column from different files?  (67%)
How to replace the second column of a file with an increasing number? (65%)

Check Demo of Advanced search and replace
seperate  find word  second column  separate  find  unit number filter  number filter  second  replace scope  scope  find 2 words  find tab  scope filter  find and replace text with a  words with number  find pattern in file replace  search replace file content  find text