SAS Quality Knowledge Base for Contact Information 25
Definitions for the Dutch, Netherlands locale are described below.
Case Definitions
Gender Analysis Definitions
Identification Analysis Definitions
Match Definitions
Parse Definitions
Pattern Analysis Definitions
Standardization Definitions
Inherited Definitions
Proper (Address) | ||
---|---|---|
Description | The Case definition for Proper (Address) propercases address strings. | |
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 Case definition for Proper (Name) propercases names. | |
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 Case definition for Proper (Organization) propercases organization name strings. | |
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.
Individual/Organization | ||
---|---|---|
Description | The Identification Analysis definition for Individual/Organization 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. |
|
Note: The results listed above reflect the default match sensitivity (85). |
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. |
|
Note: The results listed above reflect the default match sensitivity (85). |
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. |
|
Note: The results listed above reflect the default match sensitivity (85). |
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 |
Note: The results listed above reflect the default match sensitivity (85). |
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. |
|
Note: The results listed above reflect the default match sensitivity (85). |
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 |
Note: The results listed above reflect the default match sensitivity (85). |
|
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 |
Note: The results listed above reflect the default match sensitivity (85). |
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 |
Note: The results listed above reflect the default match sensitivity (85). |
|
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 |
Note: The results listed above reflect the default match sensitivity (85). |
|
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 |
Note: The results listed above reflect the default match sensitivity (85). |
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 |
Note: The results listed above reflect the default match sensitivity (85). |
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 | |
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 | |
Postbus 11363 | Building Name | ||
Street | |||
Building Number | |||
Building Number Extension | |||
PO Box | Postbus 11363 | ||
Additional Info | |||
Example 3 | Input | 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 Parse definition for Address (Full) parses complete 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 | |
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 | |
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 | |
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 | |
Baron van Nagellstraat 136A | Recipient | ||
Building/Site | |||
Street | Baron van Nagellstraat 136 | ||
Extension | A | ||
PO Box | |||
Additional Info | |||
Example 2 | Input | Output | |
Postbus 11363 | Recipient | ||
Building/Site | |||
Street | |||
Extension | |||
PO Box | Postbus 11363 | ||
Extension | |||
Example 3 | Input | 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. |
||
The Address (Global) (v23) parse definition is now deprecated and will be removed in a future release of the QKB. The Address (Global) parse definition has been replaced with a copy of the Address (Global) (v23) definition which takes advantage of the new tokens and updated processing. If you changed your jobs to use Address (Global) (v23) it is suggested that you change them back. |
Address (Global) (v23) | |||
---|---|---|---|
Description | The Address (Global) (v23) 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 | |
Baron van Nagellstraat 136A | Recipient | ||
Building/Site | |||
Street | Baron van Nagellstraat 136 | ||
Extension | A | ||
PO Box | |||
Additional Info | |||
Example 2 | Input | Output | |
Postbus 11363 | Recipient | ||
Building/Site | |||
Street | |||
Extension | |||
PO Box | Postbus 11363 | ||
Extension | |||
Example 3 | Input | 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. |
||
The Address (Global) (v23) parse definition is now deprecated and will be removed in a future release of the QKB. The Address (Global) parse definition has been replaced with a copy of the Address (Global) (v23) definition which takes advantage of the new tokens and updated processing. If you changed your jobs to use Address (Global) (v23) it is suggested that you change them back. |
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 | |
1077 ZX AMSTERDAM | City | AMSTERDAM | |
State/Province | |||
Postal Code | 1077 ZX | ||
Additional Info | |||
Example 2 | Input | 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 | |
NL-5991BZ BAARLO LB | City | BAARLO LB | |
State/Province | |||
Postal Code | NL-5991BZ | ||
Additional Info | |||
Example 4 | Input | 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 | |
1077 ZX AMSTERDAM | City | AMSTERDAM | |
State/Province | |||
Postal Code | 1077 ZX | ||
Additional Info | |||
Example 2 | Input | 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 | |
NL-5991BZ BAARLO LB | City | BAARLO LB | |
State/Province | |||
Postal Code | NL-5991BZ | ||
Additional Info | |||
Example 4 | Input | 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 Parse definition for Name (Separate Prepositions) 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 | |
Bas s'Jacob | Prefix | ||
Title | |||
Given Name | Bas | ||
Family Name Preposition | s' | ||
Family Name | Jacob | ||
Suffix | |||
Additional Info | |||
Example 2 | Input | Output | |
Jaap O'Connor | Prefix | ||
Title | |||
Given Name | Jaap | ||
Family Name Preposition | |||
Family Name | O'Connor | ||
Suffix | |||
Additional Info | |||
Example 3 | Input | 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 Parse definition for Organization parses organization names into a set of tokens. | ||
Output Tokens | Name Legal Form Site Additional Info |
||
Example 1 | Input | 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 | |
PI Flevoland Locatie Lelystad | Name | PI Flevoland | |
Legal Form | |||
Site | Locatie Lelystad | ||
Additional Info | |||
Example 3 | Input | Output | |
Automobielbedrijf Pouw BV,Zwolle | Name | Automobielbedrijf Pouw | |
Legal Form | BV | ||
Site | Zwolle | ||
Additional Info | |||
Example 4 | Input | Output | |
Automobielbedrijf Pouw Zwolle BV | Name | Automobielbedrijf Pouw Zwolle | |
Legal Form | BV | ||
Site | |||
Additional Info | |||
Remarks |
Organization (Global) | |||
---|---|---|---|
Description | The Parse definition for Organization (Global) parses organization names into a globally recognized set of tokens. | ||
Output Tokens | Name Legal Form Site Additional Info |
||
Example 1 | Input | 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 | |
PI Flevoland Locatie Lelystad | Name | PI Flevoland | |
Legal Form | |||
Site | Locatie Lelystad | ||
Additional Info | |||
Example 3 | Input | Output | |
Automobielbedrijf Pouw BV,Zwolle | Name | Automobielbedrijf Pouw | |
Legal Form | BV | ||
Site | Zwolle | ||
Additional Info | |||
Example 4 | Input | 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 Parse definition for Phone 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 | |
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 | |
0631-463670 - Mobiel | Country Code | ||
Area Code | 06 | ||
Base Number | 31-463670 | ||
Extension | |||
Line Type | Mobiel | ||
Additional Info | |||
Example 3 | Input | 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 | |
00442012345000 | Country Code | 0044 | |
Area Code | |||
Base Number | 2012345000 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 5 | Input | Output | |
0800 5 765 565 | Country Code | ||
Area Code | 0800 | ||
Base Number | 5 765 565 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 6 | Input | Output | |
0900-DRIVE | Country Code | ||
Area Code | 0900 | ||
Base Number | DRIVE | ||
Extension | |||
Line Type | |||
Additional Info | |||
Remarks |
Phone (Global) | |||
---|---|---|---|
Description | The Parse definition for Phone (Global) 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 | |
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 | |
0631-463670 - Mobiel | Country Code | ||
Area Code | 06 | ||
Base Number | 31-463670 | ||
Extension | |||
Line Type | Mobiel | ||
Additional Info | |||
Example 3 | Input | 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 | |
00442012345000 | Country Code | 0044 | |
Area Code | |||
Base Number | 2012345000 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 5 | Input | Output | |
0800 5 765 565 | Country Code | ||
Area Code | 0800 | ||
Base Number | 5 765 565 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Example 6 | Input | 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 Standardization definition for Address 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 Standardization definition for Address (Short Street Name) 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 Standardization definition for City 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 Standardization definition for City - State/Province - Postal Code standardizes address "last line" data. | |
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 Standardization definition for City - State/Province - Postal Code (International) standardizes address "last line" data and format 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 Standardization definition for Name 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 Standardization definition for Name (with Punctuation) 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 Standardization definition for Organization 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 Standardization definition for Phone 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 Standardization definition for Phone (Electronic) 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 Standardization definition for Phone (with Country Code) 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 Standardization definition for Postal Code 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 Standardization definition for Postal Code (with Country Code) 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 Standardization definition for Social Security Number standardizes Social Security numbers to nine digits without punctuation. | |
Examples | Input | Output |
/943125713/ | 943125713 | |
123-456-868 | 123456868 | |
Remarks |
State/Province | ||
---|---|---|
Description | The Standardization definition for State/Province standardizes Dutch provinces. | |
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 Standardization definition for State/Province (Postal Standard) standardizes Dutch provinces. | |
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 |