SAS Quality Knowledge Base for Contact Information 27

City - State/Province - Postal Code (Global)

Parse Definition

City - State/Province - Postal Code (Global)
Description The City - State/Province - Postal Code (Global) parse definition parses last line address information into a globally recognized set of tokens.
Output Tokens City
State/Province
Postal Code
Additional Info
Example 1 Input Output Token Output
1077 ZX AMSTERDAM City AMSTERDAM
State/Province  
Postal Code 1077 ZX
Additional Info  
Example 2 Input Output Token Output
Tabakspaadje 5601 K-3, 1693GB NIEUWERKERK A/D IJSSEL City NIEUWERKERK A/D IJSSEL
State/Province  
Postal Code 1693GB
Additional Info Tabakspaadje 5601 K-3
Example 3 Input Output Token Output
NL-5991BZ BAARLO LB City BAARLO LB
State/Province  
Postal Code NL-5991BZ
Additional Info  
Example 4 Input Output Token Output
1019DG AMERSFOORT UT City AMERSFOORT
State/Province UT
Postal Code 1019DG
Additional Info  
Remarks

If province information is a required part of the city name according to the NEN standard list of cities the province information will be parsed into the City token. Otherwise, province information will be parsed into the Province token.

Parse definitions named with the Global keyword use a set of output tokens that is consistent across every locale. Results obtained from these definitions can be stored in the same database fields as the results obtained from definitions of the same name in other locales.