Extract domain from URL?

Hello,

I have a string variable which is dynamically populated with a URL value. Some examples of the URL are:

http://cartoondoor.blogbus.com/index_5.html
http://asirir.blogspot.com/
http://neuronets.chat.ru/appendix.html

I'd like to be able to extract the domain--meaning the string value between // and /.

I've been struggling with this but can't seem to get it right. Any ideas?

strdomain = mid(query,(instr("//",query)+1,len(query)-instr("//",query)+1)

Many thanks,
J

Hi

Perhaps:

strdomain = Split(query,"/")(2)

Richard

Try something to the effect of:

=MID(query,instr("//",query)+2,instr("/",MID(query,instr("//",query)+2))-1)

I tried to use the code and get a error when using the word "query"...
Trying to use the code in Excel 2007 to extract a domain name from a string between the "//" and "/" if they exist.


I am very new to Excel, so this is confusing for me. I am not using SQL, just to Visual Basic Code, so I think that is the problem.

I'm trying to extract from one column and put just the domain name into another column.

Please start a new thread with your question. You can add a link to this thread if you find it relevant.