stateabbreviations()

The stateabbreviations( function this 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


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.