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

600k Domain list, can't clean it [Help]

Discussion in 'Black Hat SEO' started by Heraclitus, Nov 28, 2014.

  1. Heraclitus

    Heraclitus Junior Member

    Joined:
    Jan 29, 2014
    Messages:
    136
    Likes Received:
    10
    Location:
    UK
    I recently got my hands on a 600k domain list. But it has the domain and then the ip like this
    domain.com 12.12.12.12

    Is there anyway I can get rid of the ip and keep the domains only?
     
  2. PrinceVisi

    PrinceVisi Elite Member

    Joined:
    Jan 11, 2012
    Messages:
    1,919
    Likes Received:
    1,011
    Occupation:
    BusinessMan
    Location:
    Tropoja

    Sure.

    1) Copy and Paste those on Notepad.
    2) Replace the "free" space between the domains and the IPs with a tab space. (the button can be found on the left of your keyboard.)
    3) Copy everything and Paste it on Excel.

    You now have two separate columns. One for the domains and one for the IPs. ;)
     
    • Thanks Thanks x 1
  3. Heraclitus

    Heraclitus Junior Member

    Joined:
    Jan 29, 2014
    Messages:
    136
    Likes Received:
    10
    Location:
    UK
    Awesome! I also found out how to select every ip with notepad by using \d+\d+...
    Didn't know that feature of Excel, cheers!