AnsweredAssumed Answered

Indicate if characters in string match

Question asked by Terri on Dec 5, 2012
Latest reply on Dec 5, 2012 by raybaudi


Indicate if characters in string match


     First, FMPro 11 Advanced.
     Second, Mac.
     Field 1 contents: 



          Field 2 contents:




          Field 1 is a calculation field of PC & Style Number & Season & Season Year

          Field 2 is the style number


          I need a calculation that tells me if the style number part of Field 1 matches the style number of Field 2.

          Tip - there are always 6 characters after the style number.

          Tricky part - the style number is not always 6 characters long, it can be anywhere from 3-6 characters long.