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