Extracting text from container calc.

[FMStudioNewb]

Hello all,

I have a database which stores information about buildings and it has container fields storing links to drawing files. The client likes it this way so they can click on the field to pull the file from the server. I need to be able to add a link to the file on a website I am creating for them and therefore I need to extract just the file path with a "file://" prefix for the link. when I calculate getText(container_Field_Name), filemaker returns an extra part ("file:filename filemac:/Macintosh HD/Users/filepath/filename). How can I retrieve just the filepath and filename parts of this in a calculation field?

Thanks in advance

[Fitch]

There are a couple of ways to do this using Text functions.

- You could use Substitute to replace the slashes with paragraphs, then use ValueCount and GetValue to get the filepath and filename values.

- You could use Length to get the character count, then use Position to find the second slash from the end (use a negative number to count backwards), and Middle to pull out the text.

If you like to figure things out yourself, give it a try, if not let me know and I'll give you a calculation.

Edited February 2, 2010 by Guest
corrected link

[Lee Smith]

Hi Tom,

Your link didn't work for me.

Hi [color:red]FMStudioNewb, and Welcome to the forum.

This question comes up from time to time, and if you were to do a search for [color:blue]+file +referemce you will find a lot of the threads. See if this one is what you are looking for. Link

HTH

Lee

[Fitch]

Thanks, Lee, the link is corrected now, it points to the relevant FileMaker.com/help section.

The link I had posted was what I use for my own quick help. For anyone interested, I find this very useful:

On a Mac control-click (right click) on your FileMaker application, and choose Show package contents

- From there go to / Contents / Resources / English.lproj / FileMaker Pro Help /

- Open index.html

Go to script steps, functions, error codes, and bookmark them for instant access.