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:
    677
    Likes Received:
    290
    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:
    635
    Likes Received:
    414
    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:
    698
    Likes Received:
    168
    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:
    677
    Likes Received:
    290
    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:
    677
    Likes Received:
    290
    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/