AnsweredAssumed Answered

CONTAINER REFERENCE - Photo name only

Question asked by ShirleyMB4 on Mar 6, 2012
Latest reply on Mar 6, 2012 by 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!

Outcomes