Let ( [ t = GetAsText ( ContainerField ) ; pos = Position ( t ; "/Filemaker8-data/" ; 1 ; 1 ) ] ; Right ( t ; Length ( t ) - pos - 16 ) )
Note that this assumes all your images are in the same Filemaker8-data folder.
Let ( [
text = GetAsText ( ContainerField )
RightWords ( text ; WordCount ( text ) - 10)
Thanks for your speedy reply. Not being as sophisticated a programmer as you are, I was amazed at your calculation. I still don't know what "t" stands for, but whatever it does, the calculation works up to a point. The "images" I want to get is the word found on the last of the 3 lines. Each photo has a different amount of letters and words, so the "16" you used in your calculation returns a part of the first word "image" plus the rest of the data. Back to the drawing board!
Thank you very much for your calculation. Unfortunately, the same problem exists as with the previous person's calculation -- the word or character number changes with each photo so that the calculation returns the correct part in some photos, while others are missing letters. What I need is a calculation to show everything to the right of the last line's "images."
Here's another example. Does Filemaker recognize dashes as separate words? Below is what your calculation produced for this other sample.
Your calculation returned the following:
I'm afraid we may not be on the same page. You asked for a calculation that will extract "only those words following Filemaker8-data". The formula I posted looks for the string "/Filemaker8-data/" and returns anything that follows it. The number 16 in the calculation is derived from the length of the string "/Filemaker8-data/" (17) and is used to exclude this string from the result.
As I said, this assumes ALL your images are in the same parent folder named "Filemaker8-data". If not, it will return the entire text except the first 16 characters - which is what I suspect you are seing.
I want the words in the 3rd line after the word "images," not after "only those words following Filemaker8-data."
Well, then why don't you adjust the formula accordingly?
Not being an expert on programming, what I did was change the words "Filemaker 8 data" to "images," but that didn't seem to help. Should I be changing something else as well?
I believe it should be "/images/" (to make sure it's a folder and not part of the file's name), and the number should be 7.
I went to the computer where the files reside (our multi-user configuration was not done properly), and your solution works. Thank you very much! I always admire genius!