Is there a way to search for duplicate records in Notepad++?



  • Hi All,

    I currently and using Notepad++ to review user files before uploading into our provisioning system and I was curious if there was a way to search for duplicates (emails, UID’s, etc…) within Notepad++ or do I have to save the file and review it in excel to do this?

    All assistance is greatly appreciated.

    Best,
    Adam



  • Hi Adam,

    I don’t think there is a way in meaning of search. If you don’t think like use Smart Highlighting, CTRL+F3 or just search.

    But there’s a way to remove duplicates from simple list without excel (I use it a lot). So if you have simple list of values:

    value1
    value2
    value2
    value3
    value2
    

    you can simply get list of unique values:

    value1
    value2
    value3
    

    like this:

    1. You need plugin TextFX Characters
    2. Backup your current editing file !!!
    3. Set TextFX: Menu -> TextFX -> TextFX Tools:
      ✓ +Sort ascending
      ✓ +Sort outputs only UNIQUE (at column) lines
    4. Select text
    5. Use one of the actions: Menu -> TextFX -> TextFX Tools:
      a) Sort lines case sensitive (at column)
      b) Sort lines case insensitive (at column)
    6. Remember to DISABLE option +Sort outputs only UNIQUE (at column) lines, so you won’t lose data when just sorting later!

    Still it won’t work for some complex multi-column data, where only Excel filters/remove duplicates of specific data will help.


    Best regards,
    Tomas



  • Thanks really helped…:-)


Log in to reply