StateConvert ( postal ; type )
Convert US/Canadian states/provinces to full name, abbreviation or country
Average rating: 3.6 (49 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function converts any two-letter US or Canadian postal code for states/provinces to one of three formats based on the type parameter:
"Abbrev" : Associated Press-style abbreviations
example: StateConvert ( "WY" , "Abbrev" ) = Wyo.
"Full" : Full state/province name
example: StateConvert ( "IA" , "Full" ) = Iowa
"Country" : The country in which the state/province is located
example: StateConvert ( "ON" , "Country" ) = Canada
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.