Define a calculation field with this calculation:
Left ( TwelveDigitField ; 9 )
Match records using this calculation field and you can now match by the 9 digit code.
Hi, I created a new field and made that the calculation. It is not returning anything. So my calculation exactly reads Left ( Merchant Number ; 9 )
"Merchant Number" is the 12-digit field. I looked it up here: http://www.filemaker.com/11help/html/func_ref3.33.64.html and thought maybe it wasn't returning anything because I had made the new field "Number." I switched it to "Text" and it still isn't returning anything.
Any suggestions are greatly appreciated.
"Not returning anything". Does that mean that the field is blank?
This should be a field of type calculation. I think you set up a text field with an auto-enter calculation. If you add a field with an auto-enter calculation, it won't automatically update in existing records--my best guess from what you posted.
You can switch this field to be a Calculation field by changing the field type in Managed | Database | Fields. If there is a reason why you want to keep it as an auto-entered calculation, see this thread: Updating values in auto-enter calc fields without using Replace Field Contents
It works! Thank you so much. I am pretty new to this, and I had been setting up all of my calculations as auto-entered simply because that was the first way I learned how when teaching myself and didn't know there was another option. Thanks again.