stateabbreviations( function

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.