Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Eliminate duplicate rows / show unique rows (only)

    Help wanted · · · – – – · · ·
    3
    4
    34708
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jim Biwer
      Jim Biwer last edited by

      Is there a build in function that will eliminate duplicate rows automatically?
      It should have to sort that data, then eliminate duplicate rows.

      Example, given:
      aaa
      zzz
      bbb
      zzz
      ccc
      jjj
      jjj

      Return the following:
      aaa
      bbb
      ccc
      jjj
      zzz

      Thank you!

      1 Reply Last reply Reply Quote 0
      • dail
        dail last edited by

        Select all the data, do Edit > Line Operations > Sort Lines Lexicographically Ascending (or sort it by some other method in the menu). Then do a find replace in regex mode with:

        Search: ^(.+?)\R(\1\R?)+
        Replace: \1\r\n

        This assumes you are using Windows line endings. Also I believe it is possible to record all this as a macro so then you’d be able to do it with a simple menu command or shortcut.

        1 Reply Last reply Reply Quote 0
        • greenzest
          greenzest last edited by

          Hi,

          An easier way is to install the “TextFX Characters” plugin through the plugin manager; then Plugins > TextFx > TextFx Tools check the options : Sort ascending and Sort outputs only UNIQUE, click on Plugins > TextFx > TextFx Tools > Sort lines case insensitive et voilà :)

          The options are saved so you will only need to click the sort lines next time

          1 Reply Last reply Reply Quote 0
          • Jim Biwer
            Jim Biwer last edited by

            Thank you! I tried the TestFX option, it worked great. Thanks again!

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Copyright © 2014 NodeBB Forums | Contributors