CONTAINER REFERENCE - Photo name only
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!