stateabbreviations(
stateabbreviations()

The stateabbreviations( function returns a list of US state abbreviations.

Parameters

No parameters.

Description

This function returns a list of US state abbreviations in this format:

    AL:ALABAMA;AK:ALASKA; ...

This table is designed to be used with the arraylookup( and arrayreverselookup( functions.

    upperword(arraylookup(stateAbbreviations(),"CO",";",":","-")) ☞ Colorado
    upperword(arraylookup(stateAbbreviations(),"MI",";",":","-")) ☞ Michigan
    upperword(arraylookup(stateAbbreviations(),"HI",";",":","-")) ☞ Hawaii

Note: This function is equivalent to:

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

See Also

- city( -- looks up the name of a city associated with a US zip code.
- cityzip( -- returns the lowest zip code associated with a city.
- cityzips( -- returns a list of zip codes associated with a city.
- county( -- returns the name of the county associated with a US zip code.
- mapurl( -- returns a URL to display a map location.
- openmapwindow -- opens a window displaying a map of a location.
- openwebmap -- opens a web browser window displaying a map of a location.
- selectzipdistancetool -- selects records near the current record, based on zip codes.
- state( -- returns the name of the state associated with a US zip code.
- statelookup( -- converts a two letter abbreviation for a US state into the full state name.
- statename( -- converts a two letter abbreviation for a US state into the full state name.
- uspssecondaryunits( -- returns a list of USPS (United States Postal Service) secondary suffix designation abbreviations.
- uspsstreetsuffixes( -- returns a list of USPS street suffix abbreviations.
- zipdistance( -- calculates the distance between two zip codes.
- ziplatitude( -- returns the latitude of a US zip code.
- ziplongitude( -- returns the longitude of a US zip code.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.