USStateName ( StateAbbrev )

Converts the Postal Code of a US State to its two-letter Postal abbreviation

Average rating: 4.1 (34 votes) Log in to vote

Eric Troedsson
NC Credit Repair
http://www.nccreditrepair.com

Sample input:

StateAbbrev = USStateName

Sample output:

NC=North Carolina

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

Case ( StateAbbrev= "AL" ; "Alabama" ;

StateAbbrev= "AK" ; "Alaska" ;

StateAbbrev= "AZ" ; "Arizona" ;

StateAbbrev= "AR" ; "Arkansas" ; 

StateAbbrev= "CA" ; "California" ; 

StateAbbrev= "CO" ; "Colorado" ; 

StateAbbrev= "CT" ; "Connecticut" ; 

StateAbbrev= "DE" ; "Delaware" ; 

StateAbbrev= "FL" ; "Florida" ;

StateAbbrev= "GA" ; "Georgia" ; 

StateAbbrev= "HI" ; "Hawaii" ; 

StateAbbrev= "ID" ; "Idaho" ; 

StateAbbrev= "IL" ; "Illinois" ; 

StateAbbrev= "IN" ; "Indiana" ; 

StateAbbrev= "IA" ; "Iowa" ; 

StateAbbrev= "KS" ; "Kansas" ; 

StateAbbrev= "KY" ; "Kentucky" ; 

StateAbbrev= "LA" ; "Louisiana" ; 

StateAbbrev= "ME" ; "Maine" ; 

StateAbbrev= "MD" ; "Maryland" ; 

StateAbbrev= "MA" ; "Massachusetts" ; 

StateAbbrev= "MI" ; "Michigan" ; 

StateAbbrev= "MN" ; "Minnesota" ; 

StateAbbrev= "MS" ; "Mississippi" ; 

StateAbbrev= "MO" ; "Missouri" ; 

StateAbbrev= "MT" ; "Montana" ; 

StateAbbrev= "NE" ; "Nebraska" ; 

StateAbbrev= "NV" ; "Nevada" ; 

StateAbbrev= "NH" ; "New Hampshire" ; 

StateAbbrev= "NJ" ; "New Jersey" ; 

StateAbbrev= "NM" ; "New Mexico" ; 

StateAbbrev= "NY" ; "New York" ; 

StateAbbrev= "NC" ; "North Carolina" ; 

StateAbbrev= "ND" ; "North Dakota" ; 

StateAbbrev= "OH" ; "Ohio" ; 

StateAbbrev= "OK" ; "Oklahoma" ;

StateAbbrev= "OR" ; "Oregon" ; 

StateAbbrev= "PA" ; "Pennsylvania" ; 

StateAbbrev= "RI" ; "Rhode Island" ;

StateAbbrev= "SC" ; "South Carolina" ; 

StateAbbrev= "SD" ; "South Dakota" ; 

StateAbbrev= "TN" ; "Tennessee" ;

StateAbbrev= "TX" ; "Texas" ; 

StateAbbrev= "UT" ; "Utah" ; 

StateAbbrev= "VT" ; "Vermont" ;

StateAbbrev= "VA" ; "Virginia" ; 

StateAbbrev= "WA" ; "Washington" ; 

StateAbbrev= "WV" ; "West Virginia" ;

StateAbbrev= "WI" ; "Wisconsin" ; 

StateAbbrev= "WY" ; "Wyoming" )

We use this function often in our credit repair business' custom-built FileMaker application when generating documentation for the client. A simple but useful function. Thanks!

Comments

		David Head, uLearnIT Feb 16, 2010
The syntax of this CF is incorrect: USStateName ( StateAbbrev ; StateFullName ) You obviously do not need to supply the StateFullName to receive it as output! Correct syntax would be: USStateName ( StateAbbrev )

		David Head, uLearnIT Feb 16, 2010
A problem with this CF is that no error condition is passed. What happens if I enter AB as a state abbreviation - no result. There should at least be some default condition to indicate an error has occurred.

		Eric Troedsson, Durham, NC Feb 17, 2010
Please feel free to modify as needed. Works for what we require, 'nuff said.

		comment, VR Feb 17, 2010
The problem with this function is that it isn't a function at all. It's a table of data.

		Michael Rhodes, Rancho Cucamonga Dec 26, 2010
Thanks for saving me the typing!

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

USStateName ( StateAbbrev )

Comments

Support this website.

Support this website.