11 Replies Latest reply on Dec 16, 2009 11:36 AM by ShirleyMB

    EXTRACTING INFO FROM PICTURE LINK

    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!