Brian Dunning's FileMaker Custom Functions

StateConvert ( postal ; type )

Convert US/Canadian states/provinces to full name, abbreviation or country

  Average rating: 3.6 (49 votes) Log in to vote

Marc Wood   Marc Wood

Share on Facebook Share on Twitter

  Sample input:
StateConvert ( "WY" , "Abbrev" )
  Sample output:

  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



Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.