query using Left function

[tgwarrior]

I need to query a hyperlink field and only result PART of the URL.
e.g. I have many LONG URLs (http://www.abc.com/doc/part/one/x.html) I
want to query so that I ONLY get the first part of the URL
(http://www.abc.com)

I have over 5000 records and the length of the URLs are all different.
Is there a way to query using LIKE or LEFT to output everything from
the LEFT (http://) to the first single "/" (e.g. http://www.abc.com/)?
Thanks

michael munson
(e-mail address removed)

 

[Steve Huff]

Here is exacatly how you do it:

left("http://www.abc.com/doc/part/one/x.html",instr(8,"http://www.abc.com/doc/part/one/x.html","/"))

--Steve Huff

 

[tgwarrior]

This, unfortunately, doesn't solve the problem. All URLs are
different. I need to pare down the long URLs to their "base" (e.g.
www.abc.com vs. anything that would come after the .com or .edu or
..org).

 

[Dave M]

Try this:

Mid(Left("http://www.mysite.com/mysub/",Instr(8,"http://www.mysite.com/mysub
/","/")-1),8)

 

[John Vinson]

I need to query a hyperlink field and only result PART of the URL.
e.g. I have many LONG URLs (http://www.abc.com/doc/part/one/x.html) I
want to query so that I ONLY get the first part of the URL
(http://www.abc.com)

I have over 5000 records and the length of the URLs are all different.
Is there a way to query using LIKE or LEFT to output everything from
the LEFT (http://) to the first single "/" (e.g. http://www.abc.com/)?
Thanks

I take it that all the URL's in fact begin with http://? If so, try

Left(, InStr(8, [URL], "/")) The option...EDT http://community.compuserve.com/msdevapps

 

[tgwarrior]

Thanks much. This worked perfectly (the former)

 

[Steve Huff]

WHAT? Are you crazy? This is the exact solution I gave you that you said
would not work??

--Steve Huff

 

[John Vinson]

WHAT? Are you crazy? This is the exact solution I gave you that you said
would not work??

I noticed that - I posted my reply offline, if I'd seen yours I'd have
just said "ok, that's one done right, move on"!


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps