The getcitystatezip statement divides the last line of an address into separate components.
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.
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:
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
|10.0||No Change||Carried over from Panorama 6.0.|