AnsweredAssumed Answered

Open URL function

Question asked by j_morris on Feb 4, 2015
Latest reply on Feb 5, 2015 by erawson


Open URL function


I want to use the Open URL function but I need to edit the url that is stored in the field.

Here's an example:

ThesisURL field contains

I need to replace with so string should now look like this:

I also need to add "/" + GetAsText ( OCLC ) + "-MIT.pdf". In this case OCLC is a numeric field equal to 60525439.

The final URL string should look like this:

I tried using the Substitute function for the first part and that worked but when I try to add on the additional information (OCLC & -MIT.pdf) it fails.