fightstarr20
fightstarr20

Reputation: 12608

Remove duplicates in a CSV document using Notepad++

I am using notepad++ and I am trying to remove duplicates...

apple, green, supplier
banana, yellow, supplier
grapes, geen, supplier
apple, red, supplier
apple, brown, supplier
grapefruit, yellow, supplier

I would like to keep just the first instance of apple so the end result would look like this

apple, green, supplier
banana, yellow, supplier
grapes, geen, supplier
grapefruit, yellow, supplier

Anyone have an example?

Upvotes: 0

Views: 302

Answers (1)

help-info.de
help-info.de

Reputation: 7280

Lets say you have it in a text file line by line you'd go through following steps:

  • Ctrl+F
  • Choose the Mark tab.
  • Search mode: Regular expression
  • Find what: ^apple
  • Alt+M to check Bookmark line
  • Click on Mark All

enter image description here

  • Click to the first instance of apple to clear the first mark.
  • Select from the menu Search > Bookmark > Remove Bookmarked Lines.
  • Ready ...

Upvotes: 1

Related Questions