statelookup(
statelookup(
STATE
)

The statelookup( function converts a two letter abbreviation for a US state into the full state name.

Parameters

This function has one parameter:

state – The two letter abbreviation for the state name.

Description

This function converts a two letter abbreviation for a US state into the full state name.

    statelookup("CA") ☞ California
    statelookup("CO") ☞ Colorado
    statelookup("AB") ☞ AB

This function is identical to the statename( function, except for the fact that if the state does not exist, this function returns the original text instead of `""`.

Note: This function is equivalent to:

    arraylookup(stateabbreviations(),upper(thestate),";",":",thestate)

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.
- stateabbreviations( -- returns a list of US state abbreviations.
- 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.