Jump to content

getting the filename of a file referenced in a container field


This topic is 5659 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

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,

Link to comment
Share on other sites

This topic is 5659 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.