statename(
STATE
)
The statename( 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.
statename("CA") ☞ California
statename("CO") ☞ Colorado
statename("AB") ☞
This function is identical to the statelookup( function, except for the fact that if the state does not exist, the statelookup( function returns the original string instead of "".
Note: This function is equivalent to:
upperword(arraylookup(stateAbbreviations(),upper(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.
- statelookup( -- 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 | New | New in this version. |