Remove Duplicate number,How?

Discussion in 'Black Hat SEO Tools' started by bleach, Jun 12, 2010.

  1. bleach

    bleach Senior Member

    Joined:
    Oct 12, 2008
    Messages:
    962
    Likes Received:
    83
    Location:
    New York
    i have thousand of phone number and my freelancer will add new phone number everyday.
    But i want to remove duplicate numbers. How to do it?
    many thanks for your help.
    (phone numbers are in Notepad Files)
    For example
     
  2. auggie101

    auggie101 BANNED BANNED

    Joined:
    Dec 18, 2009
    Messages:
    571
    Likes Received:
    129
    you can check it through excel.. just copy the files paste it in excel, "select all" the files then in the upper part of the excel window - click "DATA" then click "remove duplicates".. All duplicates fields will be removed.. :)

    Hope it helps..
     
    • Thanks Thanks x 1
  3. VeteranSEO

    VeteranSEO Newbie

    Joined:
    Oct 14, 2009
    Messages:
    23
    Likes Received:
    6
    Occupation:
    I help companies get web traffic
    Location:
    Virginia Beach
    Or if you have it in SQL you can just do a distinct.
     
    • Thanks Thanks x 1
  4. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    8,306
    Likes Received:
    9,205
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    you can do it with Notepad++:
    navigate to TextFX/TextFX Tools, make sure "sort outputs only UNIQUE (at column) lines" is checked, hit Ctrl+A to select the entire document, then click "sort lines case sensitive (at column)" or "sort lines case insensitive (at column)"

    that's all, duplicate lines (in this case numbers) are removed
     
    • Thanks Thanks x 1
  5. noermanto

    noermanto Regular Member

    Joined:
    Nov 18, 2009
    Messages:
    305
    Likes Received:
    288
    Occupation:
    None
    Location:
    # JKT #
    Wow! all the three method were awesome.
    I thanked to all of you.
    Usually I just use some online duplicate remover (search using G)
     
  6. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    8,306
    Likes Received:
    9,205
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    yea, there are a bunch of online tools as well, but use them with caution, your leads may be stolen!
     
  7. noermanto

    noermanto Regular Member

    Joined:
    Nov 18, 2009
    Messages:
    305
    Likes Received:
    288
    Occupation:
    None
    Location:
    # JKT #
    Can you explain more..
     
  8. bleach

    bleach Senior Member

    Joined:
    Oct 12, 2008
    Messages:
    962
    Likes Received:
    83
    Location:
    New York
    nice support
     
  9. AboutBizz

    AboutBizz Regular Member

    Joined:
    Nov 24, 2007
    Messages:
    392
    Likes Received:
    152