SAS Quality Knowledge Base for Contact Information 27

City - State/Province - Postal Code

Standardization Definition

City - State/Province - Postal Code
Description The City - State/Province - Postal Code standardization definition standardizes last line address information.
Examples Input Output
NL-5991BZ BAARLO LB 5991 BZ Baarlo LB
1436BM Aldeholtwâlde 1436 BM Oldeholtwolde
3625 AE Rûgehúzen 3625 AE Ruigahuizen
Tabakspaadje 5601 K-3, 1693GB NIEUWERKERK A/D IJSSEL 1693 GB Nieuwerkerk ad IJssel (Tabakspaadje 5601 K-3)
3250 BB Spijkenisse, Zuid Holland 3250 BB Spijkenisse (Zuid-Holland)
9468GN den Haag 9468 GN 's-Gravenhage
2400AH ALPHEN/RIJN 2400 AH Alphen aan den Rijn
3400AH IJSSELSTEIN UTRECHT 3400 AH IJsselstein UT
B-1000 Brussel BE-1000 Brussel
D-2457 Hamburg DE-2457 Hamburg
RUS-127299 Moskva RU-127299 Moskva
Postcode: 1251ME Woonplaats: Amsterdam 1251 ME Amsterdam
1oo1PN Amsterdam 1001 PN Amsterdam
Remarks Whenever possible, city names are standardized according to the NEN standard list of city names. Postal codes are standardized using domestic formatting, with spaces, unless the input is a foreign postal code.