strip down a string.

JoeCooper
02-19-2008, 03:11 PM
Hi, i have a list of sites, but need to have a script to cut down each string.

like this for example:

url = "http://www.website.com/35rf/eegweg/index.html"

this needs to become

url = "www.website.com"

so strips out the http:// and anything after the first / leaving just the domain.

OnErr0r
02-19-2008, 03:21 PM
Instr for "//" (if found) then use that location plus two as the starting point and Instr for "/". Use Mid$ to get the substring.

JoeCooper
02-19-2008, 03:29 PM
hehe... yeah.. thats a good way... now for me to find out how to use it :D

but wouldnt that get everything after the http:// ?. i want whats betweek the http:// and the next /

oh and i guess id need to replace "http://" with "" and then look for first / otherwise it will find the / from http://

mkaras
02-19-2008, 07:11 PM
Start the Instr() search for the "/" at the position found for the "//" plus 2.

Flyguy
02-20-2008, 01:27 AM
You can also use this class created by Oleg Gdalevich (www.vbip.com)
Because www.vbip.com is no longer there I have attached the source.
You can use the CrackUrl method of the class.

ElderKnight
02-20-2008, 06:42 AM
I believe that you could use the Split function with "/" as the delimiter. The piece that you want should end up in the A$(2) cell of the receiving array.

dilettante
02-20-2008, 04:50 PM
Don't forget that URLs can have a port number in them, a user/pw, etc.

This is why using a generalized parser class somebody else has already debugged can be a big time saver.

What will you do about HTTPS:, FTP:, etc. protocols if you "shave off" and discard them?

MikeJoel
02-21-2008, 08:36 AM
I sometimes find it easier to start from the right side of a string and work my way back through it.

Example,
(from the right)
Find the first ":"
Find the first "/"
Is ":" position > "\" if so then we have a port #
Then just work backwards through the string to find the "://"

If you are using VB5 (like me then you don't have the Join/Split/ReadUntil/StrReverse/InstrRev/Replace string functions....
MS has a .Bas file up to give us VB5'ers those functions... (I attach it in case it helps someone)

Mike

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum