extract subdomains from list of urls?

i need to extract subdomains from list of urls. i have too many urls in T1 and i decide to only take care of the ones that own whole subdomain. any quick way for that?

 

Use Notepad++ and regex

 

Hmm, if you have Notepad++ you can press CTRL + H, set your then select "Regex" and enter the following code, then replace, remember to take your notepad++ off regex after.

Code:

.*(?<=.\w\/\w).*

 

thanks a lot lowered the number from 2000 to 200, now it will be a lot easier for me to make social signals + they will spread only on my subdomains and not on whole domains that arent mine and contain other blogs.

 

Use excel, more easy and manageable.