Display name of file in container field

[gary29422]

I would like to create a field that will display the name of the file that have been placed in a container field.  I'm using FMP 9. Thanks for your help.

 

-Gary

 

Additional info:

 

I used GetAsText and it give me this output:

 

size:612,792

image:Photos and Documents/Company Style Indicia.pdf
imagemac:/Macintosh HD/Users/GarySmith/Desktop/Envirolution/Photos and Documents/Company Style Indicia.pdf

 

I'm looking for a calculation that will just give me the file name... not the entire path.  I'm inserting both images and files into the same container field.

 

-Gary

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Legacy Versions 7 – 9" to "Layouts".

 

The General Topics are for questions about the Functions and Features that were new with the release of that Version of FileMaker.

[mr_vodka]

Try something like:

Let ( [ path = GetValue ( YourContainerField; 2 );
        val = Substitute ( path; [ ":"; ¶ ]; [ "/"; ¶ ] )
      ];
         GetValue ( val; ValueCount ( val ) )
      )

[mr_vodka]

Automatic message

This topic has been moved from "Layouts" to "Calculation Engine (Define Fields)".

[gary29422]

Thank You John.  This worked perectly.

 

-Gary