AnsweredAssumed Answered

EXTRACTING INFO FROM PICTURE LINK

Question asked by ShirleyMB on Dec 15, 2009
Latest reply on Dec 16, 2009 by ShirleyMB

Title

EXTRACTING INFO FROM PICTURE LINK

Post

We have a photo data base, and I've created a container field for the photos and a calculation field for the photo information. The calculation field should stay as is.

What I need is to make another calculation field or use a script to extract part of the information. Here is an example of the photo's link information from the calculation field:

 

size:680,553
image:PC3-1-2-6-NCJ-childrensLibrary1965.JPG
imagewin:/C:/Filemaker8-data/images/PC03-NCJ-Box-1/PC3-1-2-6-NCJ-childrensLibrary1965.JPG

 

I need to make a field to have only those words following Filemaker8-data appear (i.e. "images/PC03-NCJ-Box-1/PC3-1-2-6-NCJ-childrensLibrary1965.JPG"). I've tried numerous calculations, but one needs a definite number of words of characters, and each photo has a different number of these. Any help would be greatly appreciated!

Outcomes