EXTRACTING INFO FROM PICTURE LINK
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:
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!