Using Left or RightWords or something

[SteveGriff]

Hi there,

I have a field Image Thumbnail,

http://foo.com/whatever.jpg

what would be the function to change the above path into the following path -

http://foo.com/thumbs/whatever.jpg

and/or

http://foo.com/thumbs/whatevert.jpg

any ideas?

Thanxs

Steve Griff

[andygaunt]

Is this always going to be the same adress.

http://foo.com/

If so, a simple calc field (text)

Substitute( field x, "http://foo.com/", "http://foo.com/thumbs/")

where field x contains the original image link.

If it is going to change then you will need a more complicated calc to find everything left of the last / and substitute with that.