User: editor -- 2011-04-30 << 771 773 >> |
Hits: 3175 |
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 |