SAS Quality Knowledge Base for Contact Information 26
Definitions for the Dutch, Netherlands locale are described below.
Case Definitions
Extraction Definitions
Gender Analysis Definitions
Identification Analysis Definitions
Match Definitions
Parse Definitions
Pattern Analysis Definitions
Standardization Definitions
Inherited Definitions
Proper (Address) | ||
---|---|---|
Description | The Proper (Address) case definition propercases addresses. | |
Examples | Input | Output |
'T GOIJLAAN 1-7 | 't Goijlaan 1-7 | |
2DE ANTONIE HEINSIUSSTR 1 | 2de Antonie Heinsiusstr 1 | |
NESSTRAAT 1 T/O 2 | Nesstraat 1 t/o 2 | |
Remarks |
Proper (Name) | ||
---|---|---|
Description | The Proper (Name) case definition propercases names of individuals. | |
Examples | Input | Output |
T.A.V. DRS. K.E.A. DE VAAN RBA | t.a.v. drs. K.E.A. de Vaan RBA | |
DE HEER LUC MARC JANSSENS, BURGGRAAF | de heer Luc Marc Janssens, burggraaf | |
DHR. JAN VAN VLIES | dhr. Jan van Vlies | |
DHR. VAN VLIES | dhr. Van Vlies | |
Remarks | Propercasing is applied to given names and family names. Typical prefixes, titles, family name prepositions, and suffixes are lowercased according to Dutch common practice. |
Proper (Organization) | ||
---|---|---|
Description | The Proper (Organization) case definition propercases organization names. | |
Examples | Input | Output |
Afdeling Van Werk En Inkomen | Afdeling van Werk en Inkomen | |
akzo/pq silica vof | AKZO/PQ Silica VOF | |
N.V. BANK VOOR DE BOUWNIJVERHEID | N.V. Bank voor de Bouwnijverheid | |
Remarks |
None.
None.
Individual/Organization | ||
---|---|---|
Description | The Individual/Organization identification analysis definition determines whether a string represents the name of an individual or an organization. | |
Possible Output | INDIVIDUAL ORGANIZATION UNKNOWN |
|
Examples | Input | Output |
B.H.A. van Rijzewijk | INDIVIDUAL | |
Cuijpers MBA | INDIVIDUAL | |
H.H.J. Maas, boekhouder | INDIVIDUAL | |
Mevr. Cheritaa Arends Hulsmeijers | INDIVIDUAL | |
ActiVite | ORGANIZATION | |
GGD Kennemerland | ORGANIZATION | |
IBN Groep | ORGANIZATION | |
Floor BV | ORGANIZATION | |
Remarks |
Address | ||
---|---|---|
Description | The Address match definition generates match codes which can be used to cluster records containing addresses. | |
Max Length of Match Code | 36 characters | |
Examples | Input | Cluster ID |
ADENAUERLAAN 60 Postbus 220 | 0 | |
Postbus 220 ADENAUERLAAN 60 | 0 | |
Amstelplein 1 | 1 | |
Amstelplein 1, Rembrand Tower | 1 | |
GENERAAL URQUHARTLAAN 2 | 2 | |
GEN. URQUHARTLN 2 | 2 | |
Laan 1940-1945 | 3 | |
Laan '40 - '45 | 3 | |
Remarks |
If both street information and PO Box information are present in the same input string, both will be represented in the match code. |
|
|
Address (PO Box Only) | ||
---|---|---|
Description | The Address (PO Box Only) match definition generates match codes which can be used to cluster records containing the PO Box portion of an address. | |
Max Length of Match Code | 15 characters | |
Examples | Input | Cluster ID |
ADENAUERLAAN 60 Postbus 220 | 0 | |
Postbus 220 ADENAUERLAAN 60 | 0 | |
Postbus 220 | 0 | |
Postbus 220, Amstelplein 1 | 0 | |
P O Box 12 | 1 | |
Postbus 12 | 1 | |
Remarks |
If both street information and PO Box information are present in the same input string, only the PO Box information will be represented in the match code. |
|
|
Address (Street Only) | ||
---|---|---|
Description | The Address (Street Only) match definition generates match codes which can be used to cluster records containing the street portion of an address. | |
Max Length of Match Code | 30 characters | |
Examples | Input | Cluster ID |
ADENAUERLAAN 60 Postbus 220 | 0 | |
Postbus 220 ADENAUERLAAN 60 | 0 | |
ADENAUERLAAN 60 | 0 | |
GENERAAL URQUHARTLAAN 2 | 1 | |
GEN. URQUHARTLN 2 | 1 | |
Laan 1940-1945 | 2 | |
Laan '40 - '45 | 2 | |
Remarks |
If both street information and PO Box information are present in the same input string, only street information will be represented in the match code. |
|
|
City | ||
---|---|---|
Description | The City match definition generates match codes which can be used to cluster records containing city names. | |
Max Length of Match Code | 20 characters | |
Examples | Input | Cluster ID |
Dokkumer Nije Silen | 0 | |
Dokkumer Nieuwe Zijlen | 0 | |
Oud-Beijerland | 1 | |
Oud-Beijerland, Zuid-Holland | 1 | |
BEEK & DONK | 2 | |
BEEK EN DONK | 2 | |
BEEK/DONK | 2 | |
Amsterdam | 3 | |
Amsterdam Zuid-Oost | 3 | |
OOST,-WEST-EN MIDDELBEERS | 4 | |
Middelbeers | 4 | |
OUD VOSSEMER | 5 | |
VOSSEMER | 5 | |
OLDEBERKOOP | 6 | |
NIJEBERKOOP | 6 | |
Remarks |
|
City - State/Province - Postal Code | ||
---|---|---|
Description | The City - State/Province - Postal Code match definition generates match codes which can be used to cluster records containing last line address information. | |
Max Length of Match Code | 26 characters | |
Examples | Input | Cluster ID |
9902BW Dokkumer Nije Silen | 0 | |
9902SB Dokkumer Nieuwe Zijlen | 0 | |
8732EK Kubaard | 1 | |
8732 EM Kûbaard | 1 | |
8732EK Kübaard | 1 | |
1502RE EGMOND AD HOEF | 2 | |
1502RE EGMOND AAN DE HOEF | 2 | |
1502RE Egmond Binnen | 2 | |
1502RE EGMOND AAN ZEE | 2 | |
1000 AB AMSTERDAM | 3 | |
1000 AC AMSTERDAM | 3 | |
1000BA AMSTERDAM ZO | 3 | |
1000 CC AMSTERDAM ZUIDOOST | 3 | |
NL-1142JN | 4 | |
Postcode: 1142 JN | 4 | |
1142.JN | 4 | |
NL1142JN | 4 | |
Remarks |
On most sensitivities both the postal code and the city name contribute to the match code. You can combine match codes for these fields more freely if you parse the data and use the separate City and Postal Code definitions. |
|
|
Name (Initials) | ||
---|---|---|
Description | The Name (Initials) match definition generates match codes which can be used to cluster records containing names of individuals. | |
Max Length of Match Code | 20 characters | |
Examples | Input | Cluster ID |
Bart Hou | 0 | |
B. de la Hou | 0 | |
B.A.T.Ph.J. de la Hou | 1 | |
B.A.T.Ph.J.K. de la Hou | 1 | |
B.A.T.Ph.J.K.L. de la Hou | 1 | |
P. J. Meijaard | 2 | |
Philip John Meijaard | 2 | |
Penelope Jeanette Meijaard | 2 | |
Remarks |
|
|
This definition matches on family name plus the first letter (initial) of given names. The number of initials used is dependent on the sensitivity. |
Organization | ||
---|---|---|
Description | The Organization match definition generates match codes which can be used to cluster records containing organization names. | |
Max Length of Match Code | 35 characters | |
Examples | Input | Cluster ID |
Essent Energie Noord N.V. | 0 | |
ESSENT ENERGIE | 0 | |
Essent Milieu Wijster | 1 | |
Automobielbedrijven Pouw BV, Zwolle | 2 | |
Automobielbedrijf Pouw NV Zwolle | 2 | |
Pouw Automobiel | 2 | |
Remarks |
|
Organization (Abbr) | ||
---|---|---|
Description | The Organization (Abbr) match definition generates match codes which can be used to cluster records containing organization names based on their abbreviations. | |
Max Length of Match Code | 15 characters | |
Examples | Input | Cluster ID |
ABC NV | 0 | |
A.B.C.NV | 0 | |
Aan Boot Constructions BV | 0 | |
Arne Bergheim CopyCenter | 0 | |
ABB | 1 | |
Asea Brown Boveri | 1 | |
Remarks |
|
|
This definition has a high rate of false hits because different organization names can have the same abbreviation. For example, Aan Boot Constructions BV and Arne Bergheim CopyCenter both have the abbreviation ABC. |
Phone | ||
---|---|---|
Description | The Phone match definition generates match codes which can be used to cluster records containing phone numbers. | |
Max Length of Match Code | 22 characters | |
Examples | Input | Cluster ID |
0800-VAKANTIE | 0 | |
0800-8252684 | 0 | |
+31 20 1234567 | 1 | |
+31 (0)20 1234567 | 1 | |
020 1234567 | 1 | |
06 12345678 | 2 | |
06 12345670 | 2 | |
06 12345600 | 3 | |
045 7654321 | 4 | |
045 7654320 | 4 | |
045 7654300 | 5 | |
0412 654321 | 6 | |
0412 654320 | 6 | |
0412 654300 | 7 | |
+44 (0)2012345000 | 8 | |
+44 2012345000 | 8 | |
0165 884685 | 9 | |
165 884685 | 9 | |
Remarks |
|
|
Two domestic numbers match if one contains the area code's leading zero and the other does not, as shown in the final example. |
Postal Code | ||
---|---|---|
Description | The Postal Code match definition generates match codes which can be used to cluster records containing postal codes. | |
Max Length of Match Code | 16 characters | |
Examples | Input | Cluster ID |
1042JN | 0 | |
1042 JN | 0 | |
NL-1042JN | 0 | |
1973 AE | 1 | |
Remarks |
|
State/Province | ||
---|---|---|
Description | The State/Province match definition generates match codes which can be used to cluster records containing states and provinces. | |
Max Length of Match Code | 15 characters | |
Examples | Input | Cluster ID |
NL-FR | 0 | |
Fryslân | 0 | |
Friesland | 0 | |
Provincie: Noord-Holland | 1 | |
Province of North Holland | 1 | |
Remarks |
|
Address | |||
---|---|---|---|
Description | The Address parse definition parses addresses into a set of tokens. | ||
Output Tokens | Building Name Street Building Number Building Number Extension PO Box Additional Info |
||
Example 1 | Input | Output Token | Output |
Baron van Nagellstraat 136A | Building Name | ||
Street | Baron van Nagellstraat | ||
Building Number | 136 | ||
Building Number Extension | A | ||
PO Box | |||
Additional Info | |||
Example 2 | Input | Output Token | Output |
Postbus 11363 | Building Name | ||
Street | |||
Building Number | |||
Building Number Extension | |||
PO Box | Postbus 11363 | ||
Additional Info | |||
Example 3 | Input | Output Token | Output |
Amperestraat 1718 -3 p/a | Building Name | ||
Street | Amperestraat | ||
Building Number | 1718 | ||
Building Number Extension | 3 | ||
PO Box | |||
Additional Info | |||
Remarks |
Address (Full) | |||
---|---|---|---|
Description | The Address (Full) parse definition parses addresses containing complete two-line addresses into a set of tokens. | ||
Output Tokens | Building Name Street Building Number Extension City State/Province Postal Code Additional Info |
||
Example 1 | Input | Output Token | Output |
Mr P J Troelstralaan 2446 b 8 1422SC Abcoude | Building Name | ||
Street | Mr P J Troelstralaan | ||
Building Number | 2446 | ||
Extension | b 8 | ||
City | Abcoude | ||
State/Province | |||
Postal Code | 1422SC | ||
Additional Info | |||
Example 2 | Input | Output Token | Output |
Neslaan 94183 kmr 017 1751GH Abcoude | Building Name | ||
Street | Neslaan | ||
Building Number | 94183 | ||
Extension | |||
City | Abcoude | ||
State/Province | |||
Postal Code | 1751GH | ||
Additional Info | kmr 017 | ||
Example 3 | Input | Output Token | Output |
Postbus 1109 1001 GB AMSTERDAM | Building Name | ||
Street | |||
Building Number | |||
Extension | Postbus 1109 | ||
City | AMSTERDAM | ||
State/Province | |||
Postal Code | 1001 GB | ||
Additional Info | |||
Remarks |
Address (Global) | |||
---|---|---|---|
Description |
The Address (Global) parse definition parses addresses into a globally recognized set of tokens. |
||
Output Tokens | Recipient Building/Site Street Extension PO Box Additional Info |
||
Example 1 | Input | Output Token | Output |
Baron van Nagellstraat 136A | Recipient | ||
Building/Site | |||
Street | Baron van Nagellstraat 136 | ||
Extension | A | ||
PO Box | |||
Additional Info | |||
Example 2 | Input | Output Token | Output |
Postbus 11363 | Recipient | ||
Building/Site | |||
Street | |||
Extension | |||
PO Box | Postbus 11363 | ||
Extension | |||
Example 3 | Input | Output Token | Output |
Amperestraat 1718 -3 p/a | Recipient | ||
Building/Site | |||
Street | Amperestraat 1718 | ||
Extension | 3 | ||
PO Box | |||
Extension | |||
Remarks |
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. |
City - State/Province - Postal Code | |||
---|---|---|---|
Description | The City - State/Province - Postal Code parse definition parses last line address information into a 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 |
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. |
Name (Separate Prepositions) | |||
---|---|---|---|
Description |
The Name (Separate Prepositions) parse definition parses names of individuals into a set of tokens. |
||
Output Tokens | Prefix Title Given Name Family Name Preposition Family Name Suffix Additional Info |
||
Example 1 | Input | Output Tokens | Output |
Bas s'Jacob | Prefix | ||
Title | |||
Given Name | Bas | ||
Family Name Preposition | s' | ||
Family Name | Jacob | ||
Suffix | |||
Additional Info | |||
Example 2 | Input | Output Tokens | Output |
Jaap O'Connor | Prefix | ||
Title | |||
Given Name | Jaap | ||
Family Name Preposition | |||
Family Name | O'Connor | ||
Suffix | |||
Additional Info | |||
Example 3 | Input | Output Tokens | Output |
Dhr. ing. Maarten van der Berg Jr, Directeur | Prefix | Dhr. | |
Title | ing. | ||
Given Name | Maarten | ||
Family Name Preposition | van der | ||
Family Name | Berg | ||
Suffix | Jr | ||
Additional Info | Directeur | ||
Remarks | Dutch academic titles are parsed into Title, while business titles are parsed into Additional Info. |
Organization | |||
---|---|---|---|
Description | The Organization parse definition parses organization names into a set of tokens. | ||
Output Tokens | Name Legal Form Site Additional Info |
||
Example 1 | Input | Output Token | Output |
Waterschap Reest en Wieden BV Afd. Bibliotheek | Name | Waterschap Reest en Wieden | |
Legal Form | BV | ||
Site | |||
Additional Info | Afd. Bibliotheek | ||
Example 2 | Input | Output Token | Output |
PI Flevoland Locatie Lelystad | Name | PI Flevoland | |
Legal Form | |||
Site | Locatie Lelystad | ||
Additional Info | |||
Example 3 | Input | Output Token | Output |
Automobielbedrijf Pouw BV,Zwolle | Name | Automobielbedrijf Pouw | |
Legal Form | BV | ||
Site | Zwolle | ||
Additional Info | |||
Example 4 | Input | Output Token | Output |
Automobielbedrijf Pouw Zwolle BV | Name | Automobielbedrijf Pouw Zwolle | |
Legal Form | BV | ||
Site | |||
Additional Info | |||
Remarks |
Organization (Global) | |||
---|---|---|---|
Description | The Organization (Global) parse definition parses organization names into a set of tokens. | ||
Output Tokens | Name Legal Form Site Additional Info |
||
Example 1 | Input | Output Token | Output |
Waterschap Reest en Wieden BV Afd. Bibliotheek | Name | Waterschap Reest en Wieden | |
Legal Form | BV | ||
Site | |||
Additional Info | Afd. Bibliotheek | ||
Example 2 | Input | Output Token | Output |
PI Flevoland Locatie Lelystad | Name | PI Flevoland | |
Legal Form | |||
Site | Locatie Lelystad | ||
Additional Info | |||
Example 3 | Input | Output Token | Output |
Automobielbedrijf Pouw BV,Zwolle | Name | Automobielbedrijf Pouw | |
Legal Form | BV | ||
Site | Zwolle | ||
Additional Info | |||
Example 4 | Input | Output Token | Output |
Automobielbedrijf Pouw Zwolle BV | Name | Automobielbedrijf Pouw Zwolle | |
Legal Form | BV | ||
Site | |||
Additional Info | |||
Remarks | 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. |
Phone | |||
---|---|---|---|
Description | The Phone parse definition parses phone numbers into a set of tokens. | ||
Output Tokens | Country Code Area Code Base Number Extension Line Type Additional Info |
||
Example 1 | Input | Output Token | Output |
Kantoor: +31 (30) 639 50 41 Toestel 208 (nachten en weekdagen) | Country Code | +31 | |
Area Code | 30 | ||
Base Number | 639 50 41 | ||
Extension | 208 | ||
Line Type | Kantoor: | ||
Additional Info | (nachten en weekdagen) | ||
Example 2 | Input | Output Token | Output |
0631-463670 - Mobiel | Country Code | ||
Area Code | 06 | ||
Base Number | 31-463670 | ||
Extension | |||
Line Type | Mobiel | ||
Additional Info | |||
Example 3 | Input | Output Token | Output |
BEN Nederland B.V.: +31624001405 | Country Code | +31 | |
Area Code | 6 | ||
Base Number | 24001405 | ||
Extension | |||
Line Type | |||
Additional Info | BEN Nederland B.V.: | ||
Example 4 | Input | Output Token | Output |
00442012345000 | Country Code | 0044 | |
Area Code | |||
Base Number | 2012345000 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 5 | Input | Output Token | Output |
0800 5 765 565 | Country Code | ||
Area Code | 0800 | ||
Base Number | 5 765 565 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 6 | Input | Output Token | Output |
0900-DRIVE | Country Code | ||
Area Code | 0900 | ||
Base Number | DRIVE | ||
Extension | |||
Line Type | |||
Additional Info | |||
Remarks |
Phone (Global) | |||
---|---|---|---|
Description |
The Phone (Global) parse definition parses phone numbers into a globally recognized set of tokens. |
||
Output Tokens | Country Code Area Code Base Number Extension Line Type Additional Info |
||
Example 1 | Input | Output Token | Output |
Kantoor: +31 (30) 639 50 41 Toestel 208 (nachten en weekdagen) | Country Code | +31 | |
Area Code | 30 | ||
Base Number | 639 50 41 | ||
Extension | 208 | ||
Line Type | Kantoor: | ||
Additional Info | (nachten en weekdagen) | ||
Example 2 | Input | Output Token | Output |
0631-463670 - Mobiel | Country Code | ||
Area Code | 06 | ||
Base Number | 31-463670 | ||
Extension | |||
Line Type | Mobiel | ||
Additional Info | |||
Example 3 | Input | Output Token | Output |
BEN Nederland B.V.: +31624001405 | Country Code | +31 | |
Area Code | 6 | ||
Base Number | 24001405 | ||
Extension | |||
Line Type | |||
Additional Info | BEN Nederland B.V.: | ||
Example 4 | Input | Output Token | Output |
00442012345000 | Country Code | 0044 | |
Area Code | |||
Base Number | 2012345000 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 5 | Input | Output Token | Output |
0800 5 765 565 | Country Code | ||
Area Code | 0800 | ||
Base Number | 5 765 565 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 6 | Input | Output Token | Output |
0900-DRIVE | Country Code | ||
Area Code | 0900 | ||
Base Number | DRIVE | ||
Extension | |||
Line Type | |||
Additional Info | |||
Remarks | 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. |
None.
Address | ||
---|---|---|
Description | The Address standardization definition standardizes addresses. | |
Examples | Input | Output |
S GRAVENSLOOT 33 | 's Gravensloot 33 | |
Beatrixlaan 16 p/a | Beatrixlaan 16 | |
Weena 327-329 2nd Floor | Weena 327-329 2 Hoog | |
217 Schiphol Blvd | Schiphol Boulevard 217 | |
Boterdiep 13 tm 15 | Boterdiep 13-15 | |
Plein '40-'45 1 | Plein 1940-1945 1 | |
SCHIPHOLDIJK AB WS DE RAZENDE BOL | Schipholdijk a/b WS De Razende Bol | |
LN. V N.O.Indie 127-IV | Laan van Nieuw Oost Indie 127 IV | |
Remarks |
Address (Short Street Name) | ||
---|---|---|
Description |
The Address (Short Street Name) standardization definition standardizes addresses, using abbreviated street names and types. |
|
Examples | Input | Output |
Sint - Janshaven 1 | St-Janshvn 1 | |
Weena 327-329 2nd Floor | Weena 327-329 2 Hg | |
Postbus 7700 - Kamer 743 | Postbus 7700, Kmr 743 | |
Laan van Nieuw Oost Indie 127 iv | Ln van NOI 127 IV | |
Remarks |
|
City | ||
---|---|---|
Description | The City standardization definition standardizes city names. | |
Examples | Input | Output |
ST WILLEBRORD | Sint Willebrord | |
Ohé en Laak | Ohe en Laak | |
Emmer-Compascuüm | Emmer-Compascuum | |
Capelle a/d Ijssel | Capelle aan den IJssel | |
ELSLOO LB | Elsloo LB | |
3250 BB Spijkenisse, Zuid Holland | Spijkenisse, 3250 BB, Zuid-Holland | |
/Almere-Haven/ | Almere | |
Hoorn (NH) | Hoorn NH | |
WAAXENS GEM LITTENSERADIEL | Waaksens gem Litt | |
BEEK & DONK | Beek en Donk | |
CADIER/KER | Cadier en Keer | |
Amsterdam (Schiphol-Rijk) 1319 PS | Schiphol-Rijk, 1319 PS | |
1101 BR Amsterdam Netherlands | Amsterdam, 1101 BR, Netherlands | |
Huis ter Heide Utrecht | Huis ter Heide UT | |
Amersfoort Utrecht | Amersfoort, Utrecht | |
Remarks | Whenever possible, city names are standardized according to the NEN standard list of city names. |
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. |
City - State/Province - Postal Code (International) | ||
---|---|---|
Description | The City - State/Province - Postal Code (International) standardization definition standardizes last line address information and formats Postal Code with country code prefix. | |
Examples | Input | Output |
NL-5991BZ BAARLO LB | NL-5991BZ Baarlo LB | |
1436BM Aldeholtwâlde | NL-1436BM Oldeholtwolde | |
3625 AE Rûgehúzen | NL-3625AE Ruigahuizen | |
Tabakspaadje 5601 K-3, 1693GB NIEUWERKERK A/D IJSSEL | NL-1693GB Nieuwerkerk ad IJssel (Tabakspaadje 5601 K-3) | |
3250 BB Spijkenisse, Zuid Holland | NL-3250BB Spijkenisse (Zuid-Holland) | |
9468GN den Haag | NL-9468GN 's-Gravenhage | |
2400AH ALPHEN/RIJN | NL-2400AH Alphen aan den Rijn | |
3400AH IJSSELSTEIN UTRECHT | NL-3400AH IJsselstein UT | |
B-1000 Brussel | BE-1000 Brussel | |
D-2457 Hamburg | DE-2457 Hamburg | |
RUS-127299 Moskva | RU-127299 Moskva | |
Postcode: 1251ME Woonplaats: Amsterdam | NL-1251ME Amsterdam | |
1oo1PN Amsterdam | NL-1001PN Amsterdam | |
Remarks | Whenever possible, city names are standardized according to the NEN standard list of city names. Postal codes are standardized using international formatting, with no spaces. |
Name | ||
---|---|---|
Description | The Name standardization definition standardizes names of individuals. | |
Examples | Input | Output |
MONSIEUR LUC MARC JANSSENS | de heer Luc Marc Janssens | |
ir. A.C.C. Tuit | ir A C C Tuit | |
ing. G.J.H. Bouwmans Mba / Mbi | ing G J H Bouwmans, MBA/MBI | |
CAMPUS PRESIDENT DHR. PETER JEAN-LUC JANSSENS | de heer Peter Jean-Luc Janssens, Campus President | |
V.M. D'Abo | V M d'Abo | |
eva uitde haage | Eva uit de Haage | |
Remarks |
Name (with Punctuation) | ||
---|---|---|
Description |
The Name (with Punctuation) standardization definition standardizes names of individuals. |
|
Examples | Input | Output |
MONSIEUR LUC MARC JANSSENS | de heer Luc Marc Janssens | |
ir A C C Tuit | ir. A.C.C. Tuit | |
Ing G J H Bouwmans MBA / MBI | ing. G.J.H. Bouwmans, MBA/MBI | |
J A Aalst, CIO AI | J.A. Aalst, CIO A.I. | |
Eva v/d Fehr | Eva v.d. Fehr | |
DHR XXX JANSSENS | de heer X.X.X. Janssens | |
AMV Aerts | A.M.V. Aerts | |
Remarks | Punctuation according to Dutch common practice is applied. |
Organization | ||
---|---|---|
Description | The Organization standardization definition standardizes organization names. | |
Examples | Input | Output |
SAS Institute b.v. | SAS Institute BV | |
stichting aap | Stichting AAP | |
A.S.M. International N.V. | ASM International NV | |
Verdoorn, Schalken, en v/d Linden | Verdoorn, Schalken en Vd Linden | |
Hartog En Bikker, Den | Den Hartog en Bikker | |
Remarks |
Phone | ||
---|---|---|
Description |
The Phone standardization definition standardizes phone numbers for domestic use. |
|
Examples | Input | Output |
+31 (0)20 1234567 | 020-1234567 | |
0031 20 1234567 | 020-1234567 | |
+31 6 996 713 34 | 06-99671334 | |
Kantoor: (030) 6395041 (Nachten en Weekdagen) | 030-6395041, Kantoor, Nachten en Weekdagen | |
+442012345000 Ext. 123 | +44 2012345000 x123 | |
(023) 5673030, Toestel 3118 | 023-5673030 x3118 | |
Remarks |
Phone (Electronic) | ||
---|---|---|
Description | The Phone (Electronic) standardization definition standardizes phone numbers for automated calling systems. | |
Examples | Input | Output |
(020) 1234567 | +31201234567 | |
06 99671334 | +31699671334 | |
0031 (0)20 1234567 | +31201234567 | |
Kantoor: (030) 6395041 (Nachten en Weekdagen) | +31306395041 | |
+442012345000 Ext. 123 | +442012345000 | |
(023) 5673030, Toestel 3118 | +31235673030 | |
+31 800-VAKANTIE | +3180082526843 | |
Remarks |
Phone (with Country Code) | ||
---|---|---|
Description | The Phone (with Country Code) standardization definition standardizes phone numbers for international use. | |
Examples | Input | Output |
(020) 1234567 | +31 20 1234567 | |
06 99671334 | +31 6 99671334 | |
0031 (0)20 1234567 | +31 20 1234567 | |
Kantoor: (030) 6395041 (Nachten en Weekdagen) | +31 30 6395041, Kantoor, Nachten en Weekdagen | |
+442012345000 Ext. 123 | +44 2012345000 x123 | |
(023) 5673030, Toestel 3118 | +31 23 5673030 x3118 | |
Remarks |
Postal Code | ||
---|---|---|
Description | The Postal Code standardization definition standardizes postal codes. | |
Examples | Input | Output |
1012JN | 1012 JN | |
NL-1012JN | 1012 JN | |
JN1012 | 1012 JN | |
FR 12345 | FR-12345 | |
Remarks | Uses domestic formatting, with spaces, unless the input is a foreign postal code. |
Postal Code (with Country Code) | ||
---|---|---|
Description | The Postal Code (with Country Code) standardization definition standardizes postal codes and adds a domestic country code, unless there is already a country code in the input. | |
Examples | Input | Output |
1012JN | NL-1012JN | |
FR 12345 | FR-12345 | |
Remarks | Uses international formatting, with no spaces. |
Social Security Number | ||
---|---|---|
Description | The Social Security Number standardization definition standardizes Social Security Numbers. | |
Examples | Input | Output |
/943125713/ | 943125713 | |
123-456-868 | 123456868 | |
Remarks |
State/Province | ||
---|---|---|
Description | The State/Province standardization definition standardizes province names. | |
Examples | Input | Output |
DRENTHE | Drenthe | |
zeeland | Zeeland | |
ZE | Zeeland | |
ZLD | Zeeland | |
G E | Gelderland | |
G L D | Gelderland | |
(GLD) | Gelderland | |
Provincie: Gelderland | Gelderland | |
North Holland | Noord-Holland | |
Remarks | This definition standardizes to full name. |
State/Province (Postal Standard) | ||
---|---|---|
Description | The State/Province (Postal Standard) standardization definition standardizes provinces to a 2-letter abbreviation. | |
Examples | Input | Output |
/G E/ | GE | |
DR | DR | |
Fle. | FL | |
Flevoland | FL | |
Fr. | FR | |
Friesland | FR | |
Provincie: FR | FR | |
Remarks | This definition standardizes to a two-letter code according to ISO 3166-2. |
In addition to the definitions listed on this page, the Dutch, Netherlands locale also inherits all definitions for the Dutch language and all Global definitions.
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_NLNLD_defs.html |