Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

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 studentpress.org http://nspa.studentpress.org

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( typeNo = Case ( type = "Abbrev" ; 1 ; type = "Full" ; 2 ; type = "Country" ; 3 ; 0 ) ; Case ( postal = "AL" ; Choose ( typeNo ; postal ; "Ala." ; "Alabama" ; "USA" ) ; postal = "AK" ; Choose ( typeNo ; postal ; "Alaska" ; "Alaska" ; "USA" ) ; postal = "AZ" ; Choose ( typeNo ; postal ; "Ariz." ; "Arizona" ; "USA" ) ; postal = "AR" ; Choose ( typeNo ; postal ; "Ark." ; "Arkansas" ; "USA" ) ; postal = "CA" ; Choose ( typeNo ; postal ; "Calif." ; "California" ; "USA" ) ; postal = "CO" ; Choose ( typeNo ; postal ; "Colo." ; "Colorado" ; "USA" ) ; postal = "CT" ; Choose ( typeNo ; postal ; "Conn." ; "Connecticut" ; "USA" ) ; postal = "DE" ; Choose ( typeNo ; postal ; "Del." ; "Delaware" ; "USA" ) ; postal = "DC" ; Choose ( typeNo ; postal ; "D.C." ; "District of Columbia" ; "USA" ) ; postal = "FL" ; Choose ( typeNo ; postal ; "Fla." ; "Florida" ; "USA" ) ; postal = "GA" ; Choose ( typeNo ; postal ; "Ga." ; "Georgia" ; "USA" ) ; postal = "HI" ; Choose ( typeNo ; postal ; "Hawaii" ; "Hawaii" ; "USA" ) ; postal = "ID" ; Choose ( typeNo ; postal ; "Idaho" ; "Idaho" ; "USA" ) ; postal = "IL" ; Choose ( typeNo ; postal ; "Ill." ; "Illinois" ; "USA" ) ; postal = "IN" ; Choose ( typeNo ; postal ; "Ind." ; "Indiana" ; "USA" ) ; postal = "IA" ; Choose ( typeNo ; postal ; "Iowa" ; "Iowa" ; "USA" ) ; postal = "KS" ; Choose ( typeNo ; postal ; "Kan." ; "Kansas" ; "USA" ) ; postal = "KY" ; Choose ( typeNo ; postal ; "Ky." ; "Kentucky" ; "USA" ) ; postal = "LA" ; Choose ( typeNo ; postal ; "La." ; "Louisiana" ; "USA" ) ; postal = "ME" ; Choose ( typeNo ; postal ; "Maine" ; "Maine" ; "USA" ) ; postal = "MD" ; Choose ( typeNo ; postal ; "Md." ; "Maryland" ; "USA" ) ; postal = "MA" ; Choose ( typeNo ; postal ; "Mass." ; "Massachusetts" ; "USA" ) ; postal = "MI" ; Choose ( typeNo ; postal ; "Mich." ; "Michigan" ; "USA" ) ; postal = "MN" ; Choose ( typeNo ; postal ; "Minn." ; "Minnesota" ; "USA" ) ; postal = "MS" ; Choose ( typeNo ; postal ; "Miss." ; "Mississippi" ; "USA" ) ; postal = "MO" ; Choose ( typeNo ; postal ; "Mo." ; "Missouri" ; "USA" ) ; postal = "MT" ; Choose ( typeNo ; postal ; "Mont." ; "Montana" ; "USA" ) ; postal = "NE" ; Choose ( typeNo ; postal ; "Neb." ; "Nebraska" ; "USA" ) ; postal = "NV" ; Choose ( typeNo ; postal ; "Nev." ; "Nevada" ; "USA" ) ; postal = "NH" ; Choose ( typeNo ; postal ; "N.H." ; "New Hampshire" ; "USA" ) ; postal = "NJ" ; Choose ( typeNo ; postal ; "N.J." ; "New Jersey" ; "USA" ) ; postal = "NM" ; Choose ( typeNo ; postal ; "N.M" ; "New Mexico" ; "USA" ) ; postal = "NY" ; Choose ( typeNo ; postal ; "N.Y." ; "New York" ; "USA" ) ; postal = "NC" ; Choose ( typeNo ; postal ; "N.C." ; "North Carolina" ; "USA" ) ; postal = "ND" ; Choose ( typeNo ; postal ; "N.D." ; "North Dakota" ; "USA" ) ; postal = "OH" ; Choose ( typeNo ; postal ; "Ohio" ; "Ohio" ; "USA" ) ; postal = "OK" ; Choose ( typeNo ; postal ; "Okla." ; "Oklahoma" ; "USA" ) ; postal = "OR" ; Choose ( typeNo ; postal ; "Ore." ; "Oregon" ; "USA" ) ; postal = "PA" ; Choose ( typeNo ; postal ; "Pa." ; "Pennsylvania" ; "USA" ) ; postal = "RI" ; Choose ( typeNo ; postal ; "R.I." ; "Rhode Island" ; "USA" ) ; postal = "SC" ; Choose ( typeNo ; postal ; "S.C." ; "South Carolina" ; "USA" ) ; postal = "SD" ; Choose ( typeNo ; postal ; "S.D." ; "South Dakota" ; "USA" ) ; postal = "TN" ; Choose ( typeNo ; postal ; "Tenn." ; "Tennessee" ; "USA" ) ; postal = "TX" ; Choose ( typeNo ; postal ; "Texas" ; "Texas" ; "USA" ) ; postal = "UT" ; Choose ( typeNo ; postal ; "Utah" ; "Utah" ; "USA" ) ; postal = "VT" ; Choose ( typeNo ; postal ; "Vt." ; "Vermont" ; "USA" ) ; postal = "VA" ; Choose ( typeNo ; postal ; "Va." ; "Virginia" ; "USA" ) ; postal = "WA" ; Choose ( typeNo ; postal ; "Wash." ; "Washington" ; "USA" ) ; postal = "WV" ; Choose ( typeNo ; postal ; "W.V." ; "West Virginia" ; "USA" ) ; postal = "WI" ; Choose ( typeNo ; postal ; "Wis." ; "Wisconsin" ; "USA" ) ; postal = "WY" ; Choose ( typeNo ; postal ; "Wyo." ; "Wyoming" ; "USA" ) ; postal = "AE" ; Choose ( typeNo ; postal ; "AE" ; "Armed Forces-Europe" ; "USA" ) ; postal = "AP" ; Choose ( typeNo ; postal ; "AP" ; "Armed Forces-Pacific" ; "USA" ) ; postal = "PR" ; Choose ( typeNo ; postal ; "Puerto Rico" ; "Puerto Rico" ; "USA" ) ; postal = "GU" ; Choose ( typeNo ; postal ; "Guam" ; "Guam" ; "USA" ) ; postal = "AS" ; Choose ( typeNo ; postal ; "Am. Samoa" ; "American Samoa" ; "USA" ) ; postal = "AB" ; Choose ( typeNo ; postal ; "Alberta" ; "Alberta" ; "Canada" ) ; postal = "BC" ; Choose ( typeNo ; postal ; "B.C." ; "British Columbia" ; "Canada" ) ; postal = "MB" ; Choose ( typeNo ; postal ; "Man." ; "Manitoba" ; "Canada" ) ; postal = "NB" ; Choose ( typeNo ; postal ; "N.B." ; "New Brunswick" ; "Canada" ) ; postal = "NL" ; Choose ( typeNo ; postal ; "Newfoundland" ; "Newfoundland" ; "Canada" ) ; postal = "NS" ; Choose ( typeNo ; postal ; "N.S." ; "Nova Scotia" ; "Canada" ) ; postal = "NT" ; Choose ( typeNo ; postal ; "N.T." ; "Northwest Territories" ; "Canada" ) ; postal = "ON" ; Choose ( typeNo ; postal ; "Ont." ; "Ontario" ; "Canada" ) ; postal = "PE" ; Choose ( typeNo ; postal ; "P.E.I." ; "Prince Edward Island" ; "Canada" ) ; postal = "QC" ; Choose ( typeNo ; postal ; "Quebec" ; "Quebec" ; "Canada" ) ; postal = "SK" ; Choose ( typeNo ; postal ; "Sask." ; "Saskatchewan" ; "Canada" ) ; postal = "YT" ; Choose ( typeNo ; postal ; "Yukon Territories" ; "Yukon Territories" ; "Canada" ) ; ) ) Click to copy

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

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: