4 Replies Latest reply on Oct 12, 2010 12:13 PM by JerryRoss

    Newbie: Need help to add URL path in front of ImagePath script

    JerryRoss

      Title

      Newbie: Need help to add URL path in front of ImagePath script

      Post

      Hi all,

      I'm completely new to FM and am trying to figure out how to add some static information in front of the results of the script below.

      The script calculates the name of an image in a container field. I need to add a path in front of the resulting text like "graphics/product_images/". (The path is used for the website i'm exporting the database records to.)

      So if the file name of the image in the container field was KD33.jpg, the resulting information in the calculated filed would be "graphics/product_images/KD33.jpg".

      Can anyone help me figure out how to add this into the script below?

      Let 



      // Transform the contents of a container field named Images into text 
      ImageRef = GetAsText ( Images); 
      FileName = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/")) 
      ]; 

      Middle ( ImageRef; FileName + 1; Length ( ImageRef) - FileName)