Selecting parts of a field for querie

[wstut]

I have one field with complete url´s.

Example
http://www.rocketspanish.com/links_spanish_immersion.php

or

http://apps5.oingo.com/apps/domainp...-260com_nopop&url=http://naco.com/&hl=en&ac=s

I like to make a groupby but only from the left side up to ".com"
Is there a way to select only the text untill ".com"

Thanks

Wouter

 

[Adeptus]

including or excluding ".com"?
eg, do you want
http://apps5.oingo.com
or
http://apps5.oingo

What about sites that have a different ending, eg
http://www.access-programmers.co.uk

You can use the InStr function to find the location of one string within another, and then use Left function to select everything left of that point.

InStr([start, ]string1, string2[, compare])

Left(string, length)

I'll assume you want the whole site name, including .com (or .uk or whatever). I'd suggest searching for the "/" after the site name, so you'll need to start searching after the http:// which is 7 characters, so start at 8
You don't want the "/" included in the result, so you want 1 character less than the location of the "/"
eg:

SubUrl: Left(url, InStr(8, url, "/") -1 )

will create a calculated field called SubUrl. You can then group/sort by this field.

 

[wstut]

Thanks a lot Adeptus. Worked fine.

Wouter