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: 338
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 partially duplicated lines in a text file? (65%)
How to extract all lines that has more than 4 columns from csv file? (61%)
How to remove the xml tag and some duplicated tags of combined xml files? (60%)
How to remove/delete consecutive duplicate lines in a text file? (59%)
How to duplicate column A by the number of times in column B in csv file? (59%)
How to remove all folders in a list containg folders and files? (59%)

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