SAS Quality Knowledge Base for Contact Information 27

Phone (IFETEL)

Parse Definition

Phone (IFETEL)
Description

The Phone (IFETEL) parse definition parses an IFETEL-compliant phone number into a set of tokens.

Output Tokens Prefix
Country Code
Cellular Code
LADA
Serie
Numero
Extension
Additional Info
Example 1 Input Output Token Output
520442432604890 Prefix  
Country Code 52
Cellular Code 044
LADA 243
Serie 260
Numero 4890
Extension  
Additional Info  
Example 2 Input Output Token Output
013323456789 Prefix 01
Country Code  
Cellular Code  
LADA 33
Serie 2345
Numero 6789
Extension  
Additional Info  
Example 3 Input Output Token Output
8162047148 ext 304 Prefix  
Country Code  
Cellular Code  
LADA 81
Serie 6204
Numero 7148
Extension 304
Additional Info  
Example 4 Input Output Token Output
234 234 5678901 Prefix  
Country Code  
Cellular Code  
LADA  
Serie  
Numero  
Extension  
Additional Info 2 3 4 2 3 4 5 6 7 8 9 0 1
Remarks The input string for Example 4 contains too many digits for IFETEL compliance.

The Phone (IFETEL) definition is specific to the Spanish, Mexico locale. The purpose of the definition is to separate a telephone number into the tokens used by the IFETEL national phone number registry.

If the input string does not contain a Mexican phone number in IFETEL-compliant format, the output will have a NO SOLUTION parse result and the input string will be output in the Additional Info token as shown in Example 4, with spaces between the digits.

The recommended procedure is to use the Result code field in the Parse node of your Data Job to store the results of the parsing operation. Then the data job should use the value of the Result code field to determine how the record should be processed. Records with an "OK" Result Code should be processed as valid IFETEL phone numbers. Those with a "NO SOLUTION" or "NULL" Result Code should be processed separately, if it all.