Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

772.Advanced search and replace -- How to remove all lines with duplicate value in column B in CSV file?

User: editor -- 2011-04-30          << 771  773 >>
Hits: 2075
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to remove all lines with duplicate value in column B in CSV file?
Input Sample:
A1,BBB,C1,D1 
A2,PPP,C2,D2 
A3,BBB,C3,D3 
A4,CC,C4,D4 
A5,PPP,C5,D5
Output Sample:
A1,BBB,C1,D1 
A2,PPP,C2,D2 
A4,CC,C4,D4 
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source csv file 
2. ctrl-h open 'replace' dialog 
* set 'replace unit' to 'Line' 
* 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 all lines that have duplicate contents in CSV files? (77%)
How to merge adjacent lines having same value in column one in CSV files? (70%)
How to remove duplicate column in each line? (67%)
How to remove duplicate lines from a text file? (65%)
How to remove partially duplicated lines in a text file? (65%)
How to remove lines from file B.csv with first column come from file A.csv? (64%)
How to extract all lines that has more than 4 columns from csv file? (61%)
How to random remove x lines from a line range in text file? (60%)

Check Demo of Advanced search and replace
Keywords:
toc  duplicate  duplicat  dupl  remove all lines  values  clear  remove all line  csv  at the beginning  duplicate lines csv  remove csv  duplicate csv  duplicate column  open source remove duplicate  save duplicate lines  duplicate value remove all  remove duplicate lines