StateAbbrev ( state )

Given a USA or Canadan state name, returns corresponding two letter USPS code

Average rating: 4.6 (23 votes) Log in to vote

L. Allen Poole - Show more from this author
Creative Database Solutions NW
http://cdsnw.com

Sample input:

Wyoming

Sample output:

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

/* 2 letter postal system codes for USA and Canadian state names
L. Allen Poole
allen@cdsnw.com
v. 2022 11 01
*/

Let ( state = trim ( state ) ;
Case ( 
state = "Alabama" ; "AL" ;
state = "Alaska" ; "AK" ;
state = "Alberta" ; "AB" ;
state = "Arizona" ; "AZ" ;
state = "Arkansas" ; "AR" ;
state = "British Columbia" or state = "Colombie-Britannique"; "BC";
state = "California" ; "CA" ;
state = "Colorado" ; "CO" ;
state = "Connecticut" ; "CT" ;
state = "Delaware" ; "DE" ;
state = "District of Colombia" ; "DC" ;
state = "Florida" ; "FL" ;
state = "Georgia" ; "GA" ;
state = "Hawaii" ; "HI" ;
state = "Idaho" ; "ID" ;
state = "Illinois" ; "IL" ;
state = "Indiana" ; "IN" ;
state = "Iowa" ; "IA" ;
state = "Kansas" ; "KS" ;
state = "Kentucky" ; "KY" ;
state = "Labrador" ; "NL" ;
state = "Louisiana" ; "LA" ;
state = "Maine" ; "ME" ;
state = "Manitoba" ; "MB" ;
state = "Maryland" ; "MD" ;
state = "Massachusetts" ; "MA" ;
state = "Michigan" ; "MI" ;
state = "Minnesota" ; "MN" ;
state = "Mississippi" ; "MS" ;
state = "Missouri" ; "MO" ;
state = "Montana" ; "MT" ;
state = "Nebraska" ; "NE" ;
state = "Nevada" ; "NV" ;
state = "New Brunswick" or state = "Nouveau-Brunswick"; "NB";
state = "Newfoundland" or state = "Newfoundland and Labrador" or state = "Terre-Neuve-et-Labrador" ; "NL" ;
state = "New Hampshire" ; "NH" ;
state = "New Jersey" ; "NJ" ;
state = "New Mexico" ; "NM" ;
state = "New York" ; "NY" ;
state = "North Carolina" ; "NC" ;
state = "North Dakota" ; "ND" ;
state = "Northwest Territories" or state = "Territoires du Nord-Ouest" ; "NT" ; 
state = "Nova Scotia" or state = "Nouvelle-Écosse" ; "NS" ;
state = "Nunavut" ; "NU" ;
state = "Ohio" ; "OH" ;
state = "Oklahoma" ; "OK" ;
state = "Ontario" ; "ON" ;
state = "Oregon" ; "OR" ;
state = "Pennsylvania" ; "PA" ;
state = "Prince Edward Island" or state = "Île-du-Prince-Édouard"; "PE";
state = "Quebec" or state = "Québec" ; "QC" ;
state = "Rhode Island" ; "RI" ;
state = "Saskatchewan" ; "SK" ;
state = "South Carolina" ; "SC" ;
state = "South Dakota" ; "SD" ;
state = "Tennessee" ; "TN" ;
state = "Texas" ; "TX" ;
state = "Utah" ; "UT" ;
state = "Vermont" ; "VT" ;
state = "Virginia" ; "VA" ;
state = "Washington" ; "WA" ;
state = "West Virginia" ; "WV" ;
state = "Wisconsin" ; "WI" ;
state = "Wyoming" ; "WY" ;
state = "Yukon" ; "YT" ; 
Proper ( state ) ) )

If state name is not recognized, it's returned verbatim.

Comments

		FranÃ§ois Goulet, Montreal, QC Canada Dec 12, 2014
Hi Allen, It looks like you forgot the canadian province of New-Brunswick in your CF... FYI, in Canada we have 2 official languages - French and English. French is predominant in the province of Quebec (population: 8 million - about 23% of the total canadian population). Since I often have to create multilingual UIs I modified your custom function to integrate the french version of the provinces names...Hence the following changes in the "state" items : state = "British Columbia" or state = "Colombie-Britannique"; "BC"; state = "Prince Edward Island" or state = "ÃŽle-du-Prince-Ã‰douard"; "PE"; state = "New Brunswick" or state = "Nouveau-Brunswick"; "NB"; state = "Nova Scotia" or state = "Nouvelle-Ã‰cosse" ; "NS" ; state = "Quebec" or state = "QuÃ©bec" ; "QC" ; state = "Newfoundland and Labrador" or state = "Terre-Neuve-et-Labrador" ; "NL" ; state = "Northwest Territories" or state = "Territoires du Nord-Ouest" ; "NT" ; Please note that other canadian provinces are the same in french as in english... Thanks for your CF and have a great day, FranÃ§ois

		L. Allen Poole, Creative Database Solutions NW Nov 1, 2022
Merci bien FranÃ§ois!

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

StateAbbrev ( state )

Comments

Support this website.

Support this website.