Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1444.Advanced search and replace -- How to remove duplicate words within col 1 in tab separated file?

User: Dexter -- 2019-10-04          << 1443  1445 >>
Hits: 124
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
In a tab separated file, remove duplicate words within column 1 (case  
insensitive). This is similar to http://www.mind- 
pioneer.com/services/772_Advanced_search_and_replace.html but here we do not  
remove the entire line. We just remove the word and trailing \t
Input Sample:
BBB C1 D1  
PPP C2 D2  
BBB C3 D3  
CC C4 D4  
PPP C5 D5
Output Sample:
BBB C1 D1  
C2 D2  
C3 D3  
CC C4 D4  
C5 D5
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source file 
2. ctrl-h open 'replace' dialog 
* set 'replace unit' to 'Line' 
* set 'replace with pattern' to: 
 
* set 'if' to: 
 
* click 'advanced' tab, set 'run following at the beginning  
of replace' to: 
 
3. click 'replace', done! 
4. ctrl-s save to file.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to remove duplicate lines from a text file? (67%)
How to replace the second column in a tab seperated file? (62%)
How to remove duplicate column in each line? (61%)
How to remove consecutive duplicate words in multiple files? (61%)
How to remove partially duplicated lines in a text file? (60%)
How to remove all duplicated lines without considering the last word? (59%)
How to delete duplicate lines of a text file? (59%)
How to remove all lines with duplicate value in column B in CSV file? (58%)

Check Demo of Advanced search and replace
Keywords:
trailing  within  how to remove duplicate words wit  remove duplicate words  duplicate words  similar  remove dup  remove duplicat  remove dupl  remove duplicate  replace pioneer duplicate a line  remove trailing  advanced search and replace duplicate words  remove duplicate in replace pioneer  replace pioneer duplicate  duplicate column  open source remove duplicate  www pioneer words com