Indicate if characters in string match
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.