Finding a character in a string in a query

[Zelandakh]

I have a series of web pages but I only want the web site.<br><br>Input data:<br>get <A HREF="

http://www.somewhere.com/data/something/about.gif"

TARGET="_new">

http://www.somewhere.com/data/something/about.gif</A><br><br>Required:<br><A

HREF="

http://www.somewhere.com"

TARGET="_new">

http://www.somewhere.com</A><br><br>I

know I want to find the third &quot;/&quot; and then mid(data,12,find(?)) but I can't get which command finds string within data. <p>Zel<br><a href=mailto:zel@zelandakh.co.uk>zel@zelandakh.co.uk</a><br><a href= > </a><br>

 

[Chopper]

Zel,<br><br>Since the first 7 characters are always:

http://,

you can start looking at character 8.&nbsp;&nbsp;Use:<br><br>left([data],(instr(8,[data],&quot;/&quot-1)) <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>