AnsweredAssumed Answered

Indicate if characters in string match

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

Title

Indicate if characters in string match

Post

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

          62408426834FH2012

           

          Field 2 contents:

           

          426834

           

          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.

           

          Help?

           

          Thanks!

      

Outcomes