2 Replies Latest reply on Mar 6, 2012 2:30 PM by ShirleyMB4

    CONTAINER REFERENCE - Photo name only

    ShirleyMB4

      Title

      CONTAINER REFERENCE - Photo name only

      Post

      I need to make a calculation to get the name of the photo only (e.g. John Smith.jpg) and not the complete photo reference path in the container reference field. I'm working on FM 8.

      I had once posted this question and received a calculation which worked fine (see below), but now each reference has part of the full path showing. Here's the calculation that was given to me:

      Let ( [
      t = GetAsText (SAMPLE PHOTO ) ;
      pos = Position ( t ; "/Sample Photos/" ; 1 ; 1 )
      ] ;
      Right ( t ; Length ( t ) - pos - 21)
      )

      Any help would be appreciated!