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

Excel help! How to extract homepage domains?

Discussion in 'BlackHat Lounge' started by freezeice04, May 12, 2013.

  1. freezeice04

    freezeice04 Power Member

    Joined:
    Jul 5, 2010
    Messages:
    676
    Likes Received:
    286
    Location:
    AU
    Hi,

    I got a list of domains eg. example.com/examplepage

    I only want a list of the homepage, so in this case that would be example.com

    Is there any way I can extract the bit after the .com using excel?
     
  2. Rua999

    Rua999 Power Member

    Joined:
    Jun 25, 2011
    Messages:
    621
    Likes Received:
    398
    If you have scrapebox you can do it by using the trim to root function
     
  3. gsy159

    gsy159 Power Member

    Joined:
    Apr 29, 2011
    Messages:
    641
    Likes Received:
    156
    there should be a string split function in excel. http://example.com/bla , split that by '/' then you have http: example.com bla and you only take the second
     
  4. freezeice04

    freezeice04 Power Member

    Joined:
    Jul 5, 2010
    Messages:
    676
    Likes Received:
    286
    Location:
    AU
    Don't have scrapebox...

    Yeah once I split it, then how to I get rid of the second part? The part after the .com?
     
  5. freezeice04

    freezeice04 Power Member

    Joined:
    Jul 5, 2010
    Messages:
    676
    Likes Received:
    286
    Location:
    AU
    Ok I found a solution. For those who also want to know, I just copy and pasted into this website:
    seoweather.com/trim-urls-to-root-domain-standardise-urls-prefixes/