a container?

I am using FMP Advanced 8.5
I have a field setup that is a container to store JPGs. Is it possible to
have the path and filename display for the JPG for each record?


Thanks,

Carl

Yes, if the image is stored by reference.

Just have a calc field with a TEXT result = the container field

You will get three lines of information, including the path and filename.

"Iced Tea" <icedteas (AT) cox (DOT) net> wrote

I am having trouble trying to make the calculation to extract just the
filename?


"Bill Marriott" <wjm (AT) wjm (DOT) org> wrote

Look at Text Functions in Help: Value, Position and Middle.

My field ImageText returns these lines as text (as Bill described):

size:428,397
image:../../Desktop/Matt MVC-610F.png
imagemac:/HDX/Users/matt/Desktop/Matt MVC-610F.png

The filename is the last portion of both the second and third lines, each of which is what FileMaker calls a Value. Let's extract THE IMAGE NAME it from the second line.

MyImage =

Let (
[ theText = GetValue ( ImageText ; 2 ) ;
Start = Position ( theText ; "Matt" ; 1 ; 1 ) +5 ] ;

Middle ( theText ; Start ; 99 ) )

In English:

GetValue isolates the second line of ImageText (theText).

Position locates the first occurrence of "Matt" in theText. The beginning of the image name is 5 characters past that point (Start) .

I use Middle because I can begin at a specific point (Start) in specific text (theText) and extract enough characters (99) to guarantee we will get to the end of the line. In reality, it could be shorter, but 99 doesn't hurt anything.

The result of the above calc is the image name "MVC-610F.png"

THe Let statement is used because it helps to organize things a little better with variable names instead of cluttering up a single calculation with a whole bunch of functions. It could be done without Let, but it would be a lot more confusing. Without Let,

MyImage =

Middle ( GetValue ( ImageText ; 2 ) ; Position ( GetValue ( ImageText ; 2 ) ; "Matt" ; 1 ; 1 ) +5 ; 99 ) )

You decide.

Matt

On 01/07/2007 17:11:05 "Iced Tea" <icedteas (AT) cox (DOT) net> wrote: