This content has been marked as final. Show 3 replies
Is ProductCode always going to begin with "MIL-"? If so, then you can define Model as the following (text) calculation:Substitute ( ProductCode ; "MIL-" ; "" )If ProductCode doesn't always begin with "MIL-", it's a little tricker. Maybe something like this would work:Middle ( ProductCode ; Position ( ProductCode ; "-" ; 1 ; 1 ) + 1 ; 999999999 )
Thank you very much your answer Middle ( ProductCode ; Position ( ProductCode ; "-" ; 1 ; 1 ) + 1 ; 999999999 ) worked perfectly.
Do you recommend any material to learn these formulas and tricks?
Try the functions reference, here: http://www.filemaker.com/help/13/fmp/en/html/help_func_cat.29.1.htmlAll you can really do is dig in and familiarize yourself with the various functions. You’ll pick them up over time. If you’re having a hard time doing something, ask on here like you did and make sure you understand the answers.Here is information on the three functions I referred to in my answer: