getting the filename of a file referenced in a container field

[Mif]

My database uses container fields to store a "file reference only" version of a file. How do I capture that filename, visible in the container field, in a separate text field?

[John Mark Osborne]

Take a look at this thread. I believe it answers your question.

http://fmforums.com/forum/showtopic.php?tid/176242/post/203559/hl/container+john+mark+osborne/#203559

You can use the calculation in the script in a regular Define Database calculation field if you like.

Edited June 8, 2006 by Guest

[Mif]

Thanks John,

I'm going to give it a try. Meanwhile I persisted and came up with this which also pulled the filename out of the filepath, but is less efficient.

1. I created a text calc field "filename_path" using the name of the container field as the formula.

2. I created a text calc field "filename_only" with this formula, "Right(FILENAME_path;Length(FILENAME_path) - Position(FILENAME_path;"/";Length(FILENAME_path);-1))" and it worked.

Thanks again,