getcitystatezip
getcitystatezip
RAW
,
CITY
,
STATE
,
ZIP
,
COUNTRY

The getcitystatezip statement divides the last line of an address into separate components.

Parameters

This statement has five parameters:

raw – is text containing the combined city, state, and zip and country information in one line.

city – is a field or variable that will hold the separated city.

state – is a field or variable that will hold the separated state.

zip – is a field or variable that will hold the separated zip or postal code.

country – is a field or variable that will hold the separated country.

Description

The getzitystatezip statement analyzes a line of text containing a city, state, zip code and country. It separates this line into the individual components. The easiest way to understand this is by looking at a few examples. Here is a basic US address:

    getcitystatezip "cross city, fl 32628",City,State,Zip,Country

This will be split into four components like this:

    City ☞ Cross City
    State ☞ FL
    Zip ☞ 32628
    Country ☞

If only a zip code is supplied:

    getcitystatezip "48929",City,State,Zip,Country

The city and state will be looked up automatically.

    City ☞ Lansing
    State ☞ MI
    Zip ☞ 48929
    Country ☞

The statement can recognize Canadian postal codes:

    getcitystatezip "saskatoon, sk s7h 5c7",City,State,Zip,Country

It will correctly parse the Canadian city, state and postal code.

    City ☞ Saskatoon
    State ☞ SK
    Zip ☞ S7H 5C7
    Country ☞ CANADA

Note: Unlike US zip codes, Panorama cannot look up the city and state from a Canadian postal code.

For other countries, Panorama can separate the country name, but it does not know how to separate provinces or postal codes.

    getcitystatezip "garran ac 2605 australia",City,State,Zip,Country

It also doesn’t know how to capitalize these addresses, but it does capitalize the country name.

    City ☞  garran ac 2605
    State ☞
    Zip ☞
    Country ☞ AUSTRALIA

See Also

- getaddress -- divides the last line of an address into separate components.
- getname -- divides a person's full name into separate components.
- splitlines -- takes a chunk of text and splits it into two or more smaller chunks.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.