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: 952
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
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
Answer:
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 delete the second column in multiple text files? (70%)
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%)
How to replace the certain column with specified words? (65%)
How to replace the second character of every line to 4 in a text file? (65%)
How to search and replace words in specified column in csv file? (63%)

Check Demo of Advanced search and replace
Keywords:
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