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: 1915
Type: Advanced search and replace   
Search all Advanced search and replace examples
In a tab separated file, remove duplicate words within column 1 (case  
insensitive). This is similar to http://www.mind- 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  
Output Sample:
BBB C1 D1  
C2 D2  
C3 D3  
CC C4 D4  
C5 D5
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
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