Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1307.Advanced search and replace -- How to remove duplicate column in each line?

User: y8888 -- 2015-05-26          << 1306  1308 >>
Hits: 3209
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to delete every line in; delimited contents of the same field?
Input Sample:
abc 123;456;123 
sdf 123;789;789;123 
er1 147;147;147;147;25;147
Output Sample:
abc 123;456 
sdf 123;789 
er1 147;25
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 with pattern' to: 
 
* click 'advanced' tab: 
* set 'run following for each matched unit' to: 
 
3. click 'replace', done.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to remove the first occurrance of duplicated words in each line? (69%)
How to remove all lines with duplicate value in column B in CSV file? (67%)
How to remove duplicate lines from a text file? (65%)
How to delete last column in a csv file? (64%)
How to remove duplicate words within col 1 in tab separated file? (63%)
How to remove space at beginning of the line? (63%)
How to remove/delete first column for multiple files? (63%)
How to remove/delete the text from the '#' to the end in each line? (63%)

Check Demo of Advanced search and replace
Keywords:
delimited  duplicate column  contents  field  grep  remove duplicate  remove duplicat  remove dupl  remove dup  duplicate  delete the same line  duplicate every line  split replace contents  count duplicate  tab delimited  split file line contents  text duplicate column  remove same