Is this a container field?
And its file was inserted using Insert Picture with the store by reference option selected?
If so, then this calculation field can be defined to display the file path of the inserted file:
GetValue ( YourTable::YourContainerField ; 3 )
Select Text as the return type for this calculation.
Note: If you use Insert File, use GetValue ( YourTable::YourContainerField ; 2 )
Thank you so much!
With either of your equations, it is still only grabbing the last "section" of the file, and not the complete file path...
That "last section" should be the complete file path. Can you post an example of what you are getting and what you want?
I am getting the following: Riches.doc When i should be getting: Seth's Desktop/Documents/A&E/Riches.doc Help???
Make sure that the file was inserted with the store by reference option selected.
This doesn't work if you insert an actual copy of the file into the container field.
Right. That's what i've been doing. I've selected the "store by reference" option and then clicking on "Open". It just puts the Riches.doc (for example). I do all the actions as if i am going to insert the file, and then i just make sure to select the "store by reference" option. Am i doing something wrong?
Which insert option are you using to insert the file?
Store by reference stores the entire filepath plus additional data in the field. If you want to see all the text, define a calculation field set to return text and just enter the name of your container field as its calculation, then put this field next to your container field. You'll then see exactly what text is entered each time you insert a file or picture.
In a test file where I used insert file, I get this text:
filewin:/C:/Documents and Settings/Phil/My Documents/My Pictures/RaceCars/Bentley-Le-Mans-Racer.jpg
GetValue ( ContainerFIeld ; 2 ) will return the second line which is the complete filepath.
When I use Insert Picture, I get:
image:../../My Documents/My Pictures/RaceCars/Bentley-Le-Mans-Racer.jpg
imagewin:/C:/Documents and Settings/Phil/My Documents/My Pictures/RaceCars/Bentley-Le-Mans-Racer.jpg
And thus I use 3 instead of 2 to get the third line of text.
it worked! it worked! it worked! THANK YOU SO MUCH!!!