html link within a text field

[rlinsurf]

I have a text field which contains the availability of particular films on the internet. Some of these are also just brick and mortar locations.

I'd like to be able to format the URL's to internet locations as "links" to be able to have users click on them and go to that page. Is there a way to do this?

Thanks

All My Best,

Jeffrey

[rlinsurf]

I just tried doing a script which has Open URL and the field "Available at:" as specifying the url.

Here's an example:

This is what's in the field:

http://www.amazon.com/Looney-Tunes-Golden-Collection-Three/dp/B000ADS62G/sr=8-3/qid=1161400603/ref=pd_bbs_sr_3/104-2221467-9251903?ie=UTF8

When I just copy and paste this into Safari, it works fine. But when I activate the button, it brings up:

"We're sorry. The Web address you entered is not a functioning page on our site." From Amazon.

I then copied the URL from the 404 page at Amazon. This is the url:

http://www.amazon.com//Looney-Tunes-Golden-Collection-Three/dp/B000ADS62G/sr=8-3/qid=1161400603/ref=pd_bbs_sr_3/104-2221467-9251903?ie=UTF8

It looks exactly the same. Done by copy/paste, it brings up the page. Through FMP, 404.

What's going on?

All My Best,

Jeffrey

Looking at the two URL's I now see what's happening. Apparently, FMP is adding a second "/" after "www.amazon.com". That is *not* the way it looks within the field.

Any idea what's causing this?

Edited October 21, 2006 by Guest

[comment]

This is a known bug in version 7. You need to pre-process the URL like this:

Substitute ( URL ;

[ "http://" ; "" ] ;

[ "/" ; "%2F" ]

)

You can leave the URL as is, and do the calc in the Open URL[] script step itself.

[rlinsurf]

That did it

I haven't seen Substitute done like this before. Can you step me through what this is doing? In fact, I've never even seen the structure you're using... i.e. it looks like you're doing 2 substitutes with one substitute command... is that right?

All My Best,

Jeffrey

[comment]

Have a look at the function's reference in the Help file.

[rlinsurf]

Very nice... I really learned something this evening

Thanks :

All My Best,

Jeffrey