AnsweredAssumed Answered

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

Question asked by JOBONZ on Feb 9, 2016
Latest reply on Feb 9, 2016 by Vaughan

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)

Outcomes