1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    934
    Likes Received:
    82
    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
    Home Page:
    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:
    5,913
    Likes Received:
    7,150
    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 #
    Home Page:
    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:
    5,913
    Likes Received:
    7,150
    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 #
    Home Page:
    Can you explain more..
     
  8. bleach

    bleach Senior Member

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

    AboutBizz Jr. VIP Jr. VIP Premium Member

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