8 Replies Latest reply on Feb 9, 2016 3:07 PM by Vaughan

    I am running FM PRO V13. I'm trying to find a function similar to a SUBSTR function.


      I have a value list, the data field is character and looks like this;  AA2-19 A14-755, i NEED TO RETURN THE CHARACTERS AFTER THE "-" AS A NUMBER. Any help would be appreciated. This is the first time I have worked with FileMaker since version 2.

      Number=SUBSTR(ENTER SHELF,4,3)