USStateCode ( state )

This function takes the full name of a state and returns the US Postal Code for the state.

Average rating: 4.4 (30 votes) Log in to vote

Rajendra Serber - Show more from this author
Report Department
http://reportdept.com

Sample input:

USStateCode ( "California" )

Sample output:

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

/*
USStateCode ( state )

This function takes the full name of a state and returns the US Postal Code for the state.
If the state can not be matched the full state parameter is returned

*/

Let ( stateU = Upper( state );

Case (
stateU = "ALABAMA"
; "AL";
stateU = "ALASKA"
; "AK";
stateU = "AMERICAN SAMOA"
; "AS";
stateU = "ARIZONA"
; "AZ";
stateU = "ARKANSAS"
; "AR";
stateU = "CALIFORNIA"
; "CA";
stateU = "COLORADO"
; "CO";
stateU = "CONNECTICUT"
; "CT";
stateU = "DELAWARE"
; "DE";
stateU = "DISTRICT OF COLUMBIA"
; "DC";
stateU = "FEDERATED STATES OF MICRONESIA"
; "FM";
stateU = "FLORIDA"
; "FL";
stateU = "GEORGIA"
; "GA";
stateU = "GUAM"
; "GU";
stateU = "HAWAII"
; "HI";
stateU = "IDAHO"
; "ID";
stateU = "ILLINOIS"
; "IL";
stateU = "INDIANA"
; "IN";
stateU = "IOWA"
; "IA";
stateU = "KANSAS"
; "KS";
stateU = "KENTUCKY"
; "KY";
stateU = "LOUISIANA"
; "LA";
stateU = "MAINE"
; "ME";
stateU = "MARSHALL ISLANDS"
; "MH";
stateU = "MARYLAND"
; "MD";
stateU = "MASSACHUSETTS"
; "MA";
stateU = "MICHIGAN"
; "MI";
stateU = "MINNESOTA"
; "MN";
stateU = "MISSISSIPPI"
; "MS";
stateU = "MISSOURI"
; "MO";
stateU = "MONTANA"
; "MT";
stateU = "NEBRASKA"
; "NE";
stateU = "NEVADA"
; "NV";
stateU = "NEW HAMPSHIRE"
; "NH";
stateU = "NEW JERSEY"
; "NJ";
stateU = "NEW MEXICO"
; "NM";
stateU = "NEW YORK"
; "NY";
stateU = "NORTH CAROLINA"
; "NC";
stateU = "NORTH DAKOTA"
; "ND";
stateU = "NORTHERN MARIANA ISLANDS"
; "MP";
stateU = "OHIO"
; "OH";
stateU = "OKLAHOMA"
; "OK";
stateU = "OREGON"
; "OR";
stateU = "PALAU"
; "PW";
stateU = "PENNSYLVANIA"
; "PA";
stateU = "PUERTO RICO"
; "PR";
stateU = "RHODE ISLAND"
; "RI";
stateU = "SOUTH CAROLINA"
; "SC";
stateU = "SOUTH DAKOTA"
; "SD";
stateU = "TENNESSEE"
; "TN";
stateU = "TEXAS"
; "TX";
stateU = "UTAH"
; "UT";
stateU = "VERMONT"
; "VT";
stateU = "VIRGIN ISLANDS"
; "VI";
stateU = "VIRGINIA"
; "VA";
stateU = "WASHINGTON"
; "WA";
stateU = "WEST VIRGINIA"
; "WV";
stateU = "WISCONSIN"
; "WI";
stateU = "WYOMING"
; "WY";
stateU = "Armed Forces Africa"
; "AE";
stateU = "Armed Forces Americas"
; "AA";
stateU = "Armed Forces Canada"
; "AE";
stateU = "Armed Forces Europe"
; "AE";
stateU = "Armed Forces Middle East"
; "AE";
stateU = "Armed Forces Pacific"
; "AP"
; state
)
)

This function takes the full name of a state and returns the US Postal Code for the state. If the state can not be matched the full state parameter is returned

Comments

		David Head, uLearnIT Feb 16, 2010
Why does this CF convert the state name supplied into uppercase? This is not required for the text comparisons being used.

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

USStateCode ( state )

Comments

Support this website.

Support this website.