State-to-Abbrev ( State )
Convert and substitute U.S. State names to their 2 Letter Abbreviation
Be the first to rate this function Log in to vote
Chase Holden - Show more from this author
Merchant Services Group
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This custom function will accept any U.S. state spelling and some Canadian Provinces and replace the field with its 2 character abbreviation in CAPS. Function will also normalize the text input from any upper or lower Case characters, trim any extra spaces and remove any text formatting.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.