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
| 10.0 | No Change | Carried over from Panorama 6.0. |