Extract image path from a text field

[douggy]

Hi there,

I have a text field which contains HTML news items. These HTML items contain images and their paths.

I would like to extract all the image paths into a seperate field. Can you think of a way to do this???

example:

<P><IMG src="

http://www.url.com/Assets/Images/News/picture.jpg"

border=0></P>

Ideally I would like to extract everything apart from the image name and end up with the following....

http://www.url.com/Assets/Images/News/

Any tips would be great.

Regards
Mark

 

[THWatson]

Mark
Will this do it for you?

Left([ImagePath],InStr(1,[ImagePath],"/p")-1)

Tom