SAS Quality Knowledge Base for Contact Information 25
Definitions for the French, France 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 Proper (Address) case definition propercases addresses. |
|
Input | Output | |
Examples | 1 PASSERELLE DES REFLETS TOUR DEXIA LA DEFENSE 2 | 1 passerelle des Reflets Tour Dexia La Defense 2 |
16 RUE DE LA REPUBLIQUE IMMEUBLE LE DIAMANT B | 16 rue de la Republique immeuble le Diamant B | |
Remarks | Prepositions and street types are lowercased. |
None.
Phone (Validation) | ||
---|---|---|
Description |
The Phone (Validation) identification analysis determines whether a string represents a valid phone number. |
|
Possible Output | LANDLINE MOBILE NON-GEOGRAPHIC FOREIGN INVALID |
|
Input | Output | |
Examples | 01 22 33 44 55 | LANDLINE |
+33 2 22 33 44 55 | LANDLINE | |
09 22 33 44 55 | LANDLINE | |
06 22 33 44 55 | MOBILE | |
+33 7 22 33 44 55 | MOBILE | |
08 22 33 44 55 | NON-GEOGRAPHIC | |
118 810 | NON-GEOGRAPHIC | |
0044 2012345000 | FOREIGN | |
22 33 44 55 | INVALID | |
01 22 33 44 5 | INVALID | |
Remarks | The area code, and 8 digits in the base number, must be present in order to be considered a valid domestic telephone number (with the exception of domestic short codes), as seen in the final two examples. |
Address | ||
---|---|---|
Description |
The Address match definition generates match codes which can be used to cluster records containing addresses. |
|
Max Length of Match Code | 96 characters | |
Input | Cluster ID | |
Examples | 1 Boulevard des Brotteaux | 0 |
1 Boulevard des Brotteau | 0 | |
1 Bv des Brotteaux | 0 | |
1 Blvd des Brotteaux | 0 | |
12 rue de Épargne | 1 | |
12 rue de l'épargne | 1 | |
12 rue de l'épargne, France | 1 | |
12 rue de l'épargne, lyon | 1 | |
Remarks |
This match definition includes both street address and PO Box information 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 | 18 characters | |
Input | Cluster ID | |
Examples | 12 rue de l'épargne, BP 421 | 0 |
12 rue Épargne, BP 421 | 0 | |
BP 421 1 Blvd des Brotteaux | 0 | |
BP 421, 1 Blvd des Brotteaux | 0 | |
P O Box 421 | 0 | |
BP 421 | 0 | |
Remarks |
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 | 60 characters | |
Input | Cluster ID | |
Examples | 12 rue de l'épargne BP 421 | 0 |
12B rue de l'épargne | 0 | |
BP 421 12 rue de l'épargne | 0 | |
Remarks |
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 | |
Input | Cluster ID | |
Examples | MONT SAINT MICHEL | 0 |
Mont St Michel | 0 | |
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 | 25 characters | |
Input | Cluster ID | |
Examples | 06800 CAGNES-SUR-MER | 0 |
06800 CAGNES SUR MER | 0 | |
06800 CAGNES / MER CEDEX | 0 | |
06800 CAGNES S/MER | 0 | |
06800 CAGNE SUR MER | 0 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Name (with Suggestions) | ||
---|---|---|
Description |
The Name (with Suggestions) match definition generates match codes which can be used to cluster records containing names of individuals. |
|
Max Length of Match Code | 26 characters | |
Input | Cluster ID | |
Examples | CHANTAL AMILHAT | 0 |
CHANATL AMILHAT | 0 | |
BERNARD AMILHAT | 1 | |
BERNARD AMIRHAT | 1 | |
BRIGITTE LASSALLE | 2 | |
BRIGTTE LASSALLE | 2 | |
NATH GUIRAUD | 3 | |
NATHAIE GUIRAUD | 3 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
|
This match definition generates one or more match codes for each input string. Each match code represents a suggestion for what might be the true value of the input string; this enables two strings to be matched even when one or both strings contain a spelling mistake. For example, the name CHANTAL might match the name CHANATL, or the name NATHAIE might match the name NATH. Note that a consequence of the generation of multiple match codes is that a record might be placed in more than one cluster by a subsequent clustering operation. Therefore, special attention should be given to the entity resolution process when using this definition. For more information on suggestion-based matching, refer to the Suggestion-Based Matching section of the DataFlux Data Management Studio online Help. |
||
Some data used in support of this definition were provided by the National Institute for Statistics and Economic Studies in France on February 11, 2013. |
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 | |
Input | Cluster ID | |
Examples | Directe: +33 1 43 47 20 00 (Après 16h00) | 0 |
+33 1 43 47 20 00 | 0 | |
00 33 1 43 47 20 00 | 0 | |
(0)1 43 47 20 00 | 0 | |
04 12 34 56 78 | 1 | |
04 12 34 56 70 | 1 | |
04 12 34 56 00 | 2 | |
03 84 55 66 77 poste 1234 | 3 | |
03 84 55 66 77 poste 5678 | 3 | |
0044 2012345000 | 4 | |
+44 2012345000 | 4 | |
+44 (0)2012345000 | 4 | |
33 (1) 30 07 78 10 | 5 | |
33-1-30077810 | 5 | |
33 0825 827 829 | 6 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
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 | 15 characters | |
Input | Cluster ID | |
Examples | 75008 | 0 |
FR-75005 | 0 | |
18000 | 1 | |
Remarks |
Note: The results listed above reflect the default match sensitivity (85). |
Text | ||
---|---|---|
Description | The Text match definition generates match codes which can be used to cluster records containing general text strings. | |
Max Length of Match Code | 40 characters | |
Input | Cluster ID | |
Examples | Asistance Tel SVP - 1/2-30/4 | 0 |
ASSISTANCE TEL SVP - 01/02-30/04 | 0 | |
Creation Fiche com° Vaccinelle N°8 | 1 | |
Création Fiche com Vaccinelle numéro 8 | 1 | |
Remarks |
This is a general-purpose match definition intended for data that is not covered by any other match definition. If a match definition built for the context of the data exists, the context-specific match definition is likely to give better match results. |
|
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 | Recipient Building/Site Street Extension PO Box Additional Info |
||
Input | Output | ||
Example 1 | LEADER PRICE MARTIGUES, QUAI ALSACE LORRAINE, ANGLE BLD MONGIN | Recipient | LEADER PRICE MARTIGUES |
Building/Site | |||
Street | QUAI ALSACE LORRAINE | ||
Extension | |||
PO Box | |||
Additional Info | ANGLE BLD MONGIN | ||
Input | Output | ||
Example 2 | RUE DU CHATEAU DE L HORLOGE BATIMENT 3 APP 4 | Recipient | |
Building/Site | BATIMENT 3 | ||
Street | RUE DU CHATEAU DE L HORLOGE | ||
Extension | APP 4 | ||
PO Box | |||
Additional Info | |||
Input | Output | ||
Example 3 | ZI DU BREZET, 4/8 RUE L BLERIOT BAT 3, BP 57 | Recipient | |
Building/Site | ZI DU BREZET BAT 3 | ||
Street | 4/8 RUE L BLERIOT | ||
Extension | |||
PO Box | BP 57 | ||
Additional Info | |||
Input | Output | ||
Example 4 | Madame Ditube, Poste Restante, La Poste, 52 rue du Louvre | Recipient | Madame Ditube |
Building/Site | |||
Street | 52 rue du Louvre | ||
Extension | |||
PO Box | Poste Restante, La Poste | ||
Additional Info | |||
Remarks |
Address (Detailed) | |||
---|---|---|---|
Description |
The Address (Detailed) parse definition parses addresses into a set of tokens with detailed street information. |
||
Output Tokens | Recipient Building/Site Street Number Street Type Street Name Extension PO Box Additional Info |
||
Input | Output | ||
Example 1 | ZI DU BREZET, 4/8 RUE L BLERIOT BAT 3, BP 57 | Recipient | |
Building/Site | ZI DU BREZET BAT 3 | ||
Street Number | 4/8 | ||
Street Type | RUE | ||
Street Name | L BLERIOT | ||
Extension | |||
PO Box | BP 57 | ||
Additional Info | |||
Input | Output | ||
Example 2 | Madame Ditube, Poste Restante, La Poste, 52 rue du Louvre | Recipient | Madame Ditube |
Building/Site | |||
Street Number | 52 | ||
Street Type | rue | ||
Street Name | du Louvre | ||
Extension | |||
PO Box | Poste Restante, La Poste | ||
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 | Recipient Building/Site Street Extension PO Box City Postal Code Country Additional Info |
||
Input | Output | ||
Example 1 | Clinique Saint Augustin, 78 rue Paul Bellamy, Nantes Cedex 1, 44046 | Recipient | Clinique Saint Augustin |
Building/Site | |||
Street | 78 rue Paul Bellamy | ||
Extension | |||
PO Box | |||
City | Nantes Cedex 1 | ||
Postal Code | 44046 | ||
Country | |||
Additional Info | |||
Input | Output | ||
Example 2 | Eckes-Granini France SNC 138 rue Lavoisier Zone Industrielle Sud – BP 34014 71040 MACON Cedex 9. | Recipient | Eckes-Granini France SNC |
Building/Site | Zone Industrielle Sud | ||
Street | 138 rue Lavoisier | ||
Extension | |||
PO Box | BP 34014 | ||
City | MACON Cedex 9. | ||
Postal Code | 71040 | ||
Country | |||
Additional Info | |||
Input | Output | ||
Example 3 | Route de Bergerac - Lieu-dit Pré de Cordy, BP 63, 24202 SARLAT LA CANEDA CEDEX | Recipient | |
Building/Site | Lieu-dit Pré de Cordy | ||
Street | Route de Bergerac | ||
Extension | |||
PO Box | BP 63 | ||
City | SARLAT LA CANEDA CEDEX | ||
Postal Code | 24202 | ||
Country | |||
Additional Info | |||
Input | Output | ||
Example 4 | 32/34 RUE MARBEUF, F-75374 PARIS CEDEX 08 | Recipient | |
Building/Site | |||
Street | |||
Extension | |||
PO Box | |||
City | |||
Postal Code | |||
Country | |||
Additional Info | |||
Remarks |
Address (Full) (AFNOR) | |||
---|---|---|---|
Description |
The Address (Full) (AFNOR) parse definition parses addresses containing complete two-line addresses into a set of tokens defined by AFNOR. |
||
Output Tokens | Line 1 Line 2 Line 3 Line 4 Line 5 Line 6 |
||
Input | Output | ||
Example 1 | Eckes-Granini France SNC 138 rue Lavoisier Zone Industrielle Sud – BP 34014 71040 MACON Cedex 9. | Line 1 | Eckes-Granini France SNC |
Line 2 | |||
Line 3 | Zone Industrielle Sud | ||
Line 4 | 138 rue Lavoisier | ||
Line 5 | BP 34014 | ||
Line 6 | 71040 MACON Cedex 9. | ||
Input | Output | ||
Example 2 | Zone Industrielle - BP 268, 3 rue Lavoisier | Line 1 | |
Line 2 | |||
Line 3 | Zone Industrielle | ||
Line 4 | 3 rue Lavoisier | ||
Line 5 | BP 268 | ||
Line 6 | |||
Input | Output | ||
Example 3 | 24 ALLEE DES EUCALYPTUS LES HAMEAUX DU SOLEIL 06270 VILLENEUVE LOUBET | Line 1 | |
Line 2 | |||
Line 3 | LES HAMEAUX DU SOLEIL | ||
Line 4 | 24 ALLEE DES EUCALYPTUS | ||
Line 5 | |||
Line 6 | 06270 VILLENEUVE LOUBET | ||
Input | Output | ||
Example 4 | APT A 81 RUE LAURISTON BÂTIMENT B 75116 PARIS FRANCE | Line 1 | |
Line 2 | APT A | ||
Line 3 | BÂTIMENT B | ||
Line 4 | 81 RUE LAURISTON | ||
Line 5 | |||
Line 6 | 75116 PARIS | ||
Input | Output | ||
Example 5 | LEADER PRICE MARTIGUES, QUAI ALSACE LORRAINE, ANGLE BLD MONGIN | Line 1 | LEADER PRICE MARTIGUES |
Line 2 | |||
Line 3 | |||
Line 4 | QUAI ALSACE LORRAINE | ||
Line 5 | |||
Line 6 | |||
Remarks | The scope of this definition is to parse French addresses only. The AFNOR definition requires a 7th line for Country in international addresses, this will not be used in domestic addresses. Therefore, there is no Line 7 token in the Address (Full) (AFNOR) Parse definition. Furthermore, there is no Additional Info token. If additional information exists in the input, it is not parsed to the output. |
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 |
||
Input | Output | ||
Example 1 | LEADER PRICE MARTIGUES, QUAI ALSACE LORRAINE, ANGLE BLD MONGIN | Recipient | LEADER PRICE MARTIGUES |
Building/Site | |||
Street | QUAI ALSACE LORRAINE | ||
Extension | |||
PO Box | |||
Additional Info | ANGLE BLD MONGIN | ||
Input | Output | ||
Example 2 | RUE DU CHATEAU DE L HORLOGE BATIMENT 3 APP 4 | Recipient | |
Building/Site | BATIMENT 3 | ||
Street | RUE DU CHATEAU DE L HORLOGE | ||
Extension | APP 4 | ||
PO Box | |||
Additional Info | |||
Input | Output | ||
Example 3 | ZI DU BREZET, 4/8 RUE L BLERIOT BAT 3, BP 57 | Recipient | |
Building/Site | ZI DU BREZET BAT 3 | ||
Street | 4/8 RUE L BLERIOT | ||
Extension | |||
PO Box | BP 57 | ||
Additional Info | |||
Input | Output | ||
Example 4 | Madame Ditube, Poste Restante, La Poste, 52 rue du Louvre | Recipient | Madame Ditube |
Building/Site | |||
Street | 52 rue du Louvre | ||
Extension | |||
PO Box | Poste Restante, La Poste | ||
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. | ||
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 |
||
Input | Output | ||
Example 1 | LEADER PRICE MARTIGUES, QUAI ALSACE LORRAINE, ANGLE BLD MONGIN | Recipient | LEADER PRICE MARTIGUES |
Building/Site | |||
Street | QUAI ALSACE LORRAINE | ||
Extension | |||
PO Box | |||
Additional Info | ANGLE BLD MONGIN | ||
Input | Output | ||
Example 2 | RUE DU CHATEAU DE L HORLOGE BATIMENT 3 APP 4 | Recipient | |
Building/Site | BATIMENT 3 | ||
Street | RUE DU CHATEAU DE L HORLOGE | ||
Extension | APP 4 | ||
PO Box | |||
Additional Info | |||
Input | Output | ||
Example 3 | ZI DU BREZET, 4/8 RUE L BLERIOT BAT 3, BP 57 | Recipient | |
Building/Site | ZI DU BREZET BAT 3 | ||
Street | 4/8 RUE L BLERIOT | ||
Extension | |||
PO Box | BP 57 | ||
Additional Info | |||
Input | Output | ||
Example 4 | Madame Ditube, Poste Restante, La Poste, 52 rue du Louvre | Recipient | Madame Ditube |
Building/Site | |||
Street | 52 rue du Louvre | ||
Extension | |||
PO Box | Poste Restante, La Poste | ||
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. | ||
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 | Geographical City Postal Code City Cedex Cedex Number Special Distribution Special Distribution Number Department Administrative District |
||
Input | Output | ||
Example 1 | 49024 Angers Cedex 2 | Geographical City | |
Postal Code | 49024 | ||
City | Angers | ||
Cedex | Cedex | ||
Cedex Number | 2 | ||
Special Distribution | |||
Special Distribution Number | |||
Department | |||
Administrative District | |||
Input | Output | ||
Example 2 | 77210 AVON | Geographical City | |
Postal Code | 77210 | ||
City | AVON | ||
Cedex | |||
Cedex Number | |||
Special Distribution | |||
Special Distribution Number | |||
Department | |||
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 |
||
Input | Output | ||
Example 1 | 49024 Angers Cedex 2 | City | Angers Cedex 2 |
State/Province | |||
Postal Code | 49024 | ||
Additional Info | |||
Input | Output | ||
Example 2 | 57220 BOULAY MOSELLE | City | BOULAY MOSELLE |
State/Province | |||
Postal Code | 57220 | ||
Additional Info | |||
Input | Output | ||
Example 3 | 77210 AVON | City | AVON |
State/Province | |||
Postal Code | 77210 | ||
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 |
||
Input | Output | ||
Example 1 | Travail: +33 (1) 47 53 38 41 poste 3118 (soirs et les weekends) | Country Code | +33 |
Area Code | 1 | ||
Base Number | 47 53 38 41 | ||
Extension | 3118 | ||
Line Type | Travail: | ||
Additional Info | (soirs et les weekends) | ||
Input | Output | ||
Example 2 | 00 33 160621111 | Country Code | 00 33 |
Area Code | 1 | ||
Base Number | 60621111 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 3 | +44 2012345000 | Country Code | +44 |
Area Code | |||
Base Number | 2012345000 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 4 | 01 47 53 37 30 (Mais) | Country Code | |
Area Code | 01 | ||
Base Number | 47 53 37 30 | ||
Extension | |||
Line Type | (Mais) | ||
Additional Info | |||
Input | Output | ||
Example 5 | SAS France: +33 1 60-62-11-11 | Country Code | +33 |
Area Code | 1 | ||
Base Number | 60-62-11-11 | ||
Extension | |||
Line Type | |||
Additional Info | SAS France: | ||
Input | Output | ||
Example 6 | SAS France: (0)1 60-62-11-11 x1234 | Country Code | |
Area Code | (0)1 | ||
Base Number | 60-62-11-11 | ||
Extension | 1234 | ||
Line Type | |||
Additional Info | SAS France: | ||
Input | Output | ||
Example 7 | Numéro vert: 08 25827829 | Country Code | |
Area Code | 08 | ||
Base Number | 25827829 | ||
Extension | |||
Line Type | Numéro vert: | ||
Additional Info | |||
Input | Output | ||
Example 8 | 33 (1) 30 07 78 10 | Country Code | 33 |
Area Code | 1 | ||
Base Number | 30 07 78 10 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 9 | 33 0825 827 829 | Country Code | 33 |
Area Code | 08 | ||
Base Number | 25 827 829 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 10 | 33-1-30797979 | Country Code | 33 |
Area Code | 1 | ||
Base Number | 30797979 | ||
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 |
||
Input | Output | ||
Example 1 | Travail: +33 (1) 47 53 38 41 poste 3118 (soirs et les weekends) | Country Code | +33 |
Area Code | 1 | ||
Base Number | 47 53 38 41 | ||
Extension | 3118 | ||
Line Type | Travail: | ||
Additional Info | (soirs et les weekends) | ||
Input | Output | ||
Example 2 | 00 33 160621111 | Country Code | 00 33 |
Area Code | 1 | ||
Base Number | 60621111 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 3 | +44 2012345000 | Country Code | +44 |
Area Code | |||
Base Number | 2012345000 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 4 | 01 47 53 37 30 (Mais) | Country Code | |
Area Code | 01 | ||
Base Number | 47 53 37 30 | ||
Extension | |||
Line Type | (Mais) | ||
Additional Info | |||
Input | Output | ||
Example 5 | SAS France: +33 1 60-62-11-11 | Country Code | +33 |
Area Code | 1 | ||
Base Number | 60-62-11-11 | ||
Extension | |||
Line Type | |||
Additional Info | SAS France: | ||
Input | Output | ||
Example 6 | SAS France: (0)1 60-62-11-11 x1234 | Country Code | |
Area Code | (0)1 | ||
Base Number | 60-62-11-11 | ||
Extension | 1234 | ||
Line Type | |||
Additional Info | SAS France: | ||
Input | Output | ||
Example 7 | Numéro vert: 08 25827829 | Country Code | |
Area Code | 08 | ||
Base Number | 25827829 | ||
Extension | |||
Line Type | Numéro vert: | ||
Additional Info | |||
Input | Output | ||
Example 8 | 33 (1) 30 07 78 10 | Country Code | 33 |
Area Code | 1 | ||
Base Number | 30 07 78 10 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 9 | 33 0825 827 829 | Country Code | 33 |
Area Code | 08 | ||
Base Number | 25 827 829 | ||
Extension | |||
Line Type | |||
Additional Info | |||
Input | Output | ||
Example 10 | 33-1-30797979 | Country Code | 33 |
Area Code | 1 | ||
Base Number | 30797979 | ||
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. |
Social Security Number | |||
---|---|---|---|
Description |
The Social Security Number parse definition parses Social Security Numbers (SSN/NIR) into set of tokens. |
||
Output Tokens | Gender Year of Birth Month of Birth Department of Birth City of Birth Order Number Key |
||
Input | Output | ||
Example 1 | 181099744161124 | Gender | 1 |
Year of Birth | 81 | ||
Month of Birth | 09 | ||
Department of Birth | 974 | ||
City of Birth | 41 | ||
Order Number | 611 | ||
Key | 24 | ||
Input | Output | ||
Example 2 | 1.81.09.974.41.611.24 | Gender | 1 |
Year of Birth | 81 | ||
Month of Birth | 09 | ||
Department of Birth | 974 | ||
City of Birth | 41 | ||
Order Number | 611 | ||
Key | 24 | ||
Input | Output | ||
Example 3 | 1/12/01/1A/678/345/01 | Gender | 1 |
Year of Birth | 12 | ||
Month of Birth | 01 | ||
Department of Birth | 1A | ||
City of Birth | 678 | ||
Order Number | 345 | ||
Key | 01 | ||
Input | Output | ||
Example 4 | 5050599345023 | Gender | 5 |
Year of Birth | 05 | ||
Month of Birth | 05 | ||
Department of Birth | 99 | ||
City of Birth | 345 | ||
Order Number | 023 | ||
Key | |||
Remarks | The examples do not use real social security numbers. |
None.
Address | ||
---|---|---|
Description |
The Address standardization definition standardizes addresses. |
|
Input | Output | |
Examples | 123, COURS ALBERT THOMAS | 123 cours Albert Thomas |
10 BIS Rue Wellington, Edifice LANGEVIN | Edifice Langevin, 10 bis rue Wellington | |
Remarks |
Address (AFNOR) | ||
---|---|---|
Description |
The Address (AFNOR) standardization definition standardizes addresses according to AFNOR standards. |
|
Input | Output | |
Examples | ( Maison de Plein Pied ) | MAISON DE PLEIN PIED |
Rés. l'Iliade, Bât. A | RÉS L ILIADE BÂT A | |
120, rue d'Orléans | 120 RUE D ORLÉANS | |
11590 Sallèles-d'Aude | 11590 SALLÈLES D AUDE | |
Remarks | This definition is designed to be applied to one line at a time. For example, the output lines that are listed Line 1 through Line 6 from the Address (Full) (AFNOR) Parse definition. This is a lightweight standardization definition that supports some of the standardization rules defined by AFNOR. It does not perform any context-dependent standardization. The step-by-step reduction of lines that are longer than 38 characters is not supported. |
City | ||
---|---|---|
Description |
The City standardization definition standardizes city names. |
|
Input | Output | |
Examples | MONT ST MICHEL | Le Mont-Saint-Michel |
GRENADE L ADOUR | Grenade-sur-l'Adour | |
Remarks |
City - State/Province - Postal Code | ||
---|---|---|
Description |
The City - State/Province - Postal Code standardization definition standardizes last line address information. |
|
Input | Output | |
Examples | Montferrier sur Lez F-34092 Montpellier Cdx 05 | MONTFERRIER-SUR-LEZ 34092 MONTPELLIER CEDEX 5 |
03160 bourbon l archamdault | 03160 BOURBON-L'ARCHAMBAULT | |
Remarks | This definition uppercases all output. This is done because AFNOR regulations provided by the French postal service which requires the last line of an address to be in uppercase. |
Phone | ||
---|---|---|
Description |
The Phone standardization definition standardizes phone numbers for domestic use. |
|
Input | Output | |
Examples | +33 01 60 62 11 11 | 01 60 62 11 11 |
BUREAU: (01)60621111 | 01 60 62 11 11, Bureau | |
03 85 82 49 40 Poste 456 | 03 85 82 49 40 x456 | |
03 85 82 49 40 Ext 456 | 03 85 82 49 40 x456 | |
02.44.55.66.77 | 02 44 55 66 77 | |
2 44 55 66 77 | 02 44 55 66 77 | |
(1) 6062 1111 | 01 60 62 11 11 | |
0044 (0)20 12345000 | +44 2012345000 | |
Remarks |
Phone (Electronic) | ||
---|---|---|
Description | The Phone (Electronic) standardization definition standardizes phone numbers for automated calling systems. | |
Input | Output | |
Examples | Travail: +33 (1) 47 53 38 41 poste 3118 (soirs et les weekends) | +33147533841 |
Fax: +33 1 60 62 11 11 | +33160621111 | |
02 85 82 49 40 Poste 456 | +33285824940 | |
1 60 62 11 11 | +33160621111 | |
0044 (0)20 12345000 | +442012345000 | |
Remarks |
Phone (with Country Code) | ||
---|---|---|
Description |
The Phone (with Country Code) standardization definition standardizes phone numbers for international use. |
|
Input | Output | |
Examples | 01 60 62 11 11 | +33 1 60 62 11 11 |
BUREAU: (01)60621111 | +33 1 60 62 11 11, Bureau | |
03 85 82 49 40 Poste 456 | + 33 3 85 82 49 40 x456 | |
03 85 82 49 40 Ext 456 | +33 3 85 82 49 40 x456 | |
+33 2.44.55.66.77 | +33 2 44 55 66 77 | |
2 44 55 66 77 | +33 2 44 55 66 77 | |
0044 (0)20 12345000 | +44 2012345000 | |
Remarks |
Postal Code | ||
---|---|---|
Description |
The Postal Code standardization definition standardizes postal codes. |
|
Input | Output | |
Examples | 75008 | 75008 |
FR-75005 | 75005 | |
18000 | 18000 | |
Remarks |
Social Security Number (Electronic) | ||
---|---|---|
Description |
The Social Security Number (Electronic) standardization definition standardizes Social Security Numbers for electronic storage. |
|
Input | Output | |
Examples | 181099744161124 | 181099744161124 |
1.81.09.974.41.611.24 | 181099744161124 | |
1/12/01/1A/678/345/01 | 112011A67834501 | |
5050599345023 | 5050599345023 | |
Remarks |
Social Security Number (Printed) | ||
---|---|---|
Description | The Social Security Number (Printed) standardization definition standardizes Social Security Numbers for printout. | |
Input | Output | |
Examples | 181099744161124 | 1 81 09 974 41 611 24 |
1.81.09.974.41.611.24 | 1 81 09 974 41 611 24 | |
1/12/01/1A/678/345/01 | 1 12 01 1A 678 345 01 | |
5050599345023 | 5 05 05 99 345 023 | |
Remarks |
In addition to the definitions listed on this page, the French, France locale also inherits all definitions for the French language and all Global definitions.
Documentation Feedback: yourturn@sas.com
|
Doc ID: QKBCI_FRFRA_defs.html |