SAS Quality Knowledge Base for Contact Information 27

Phone

Parse Definition

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
+20-2-2464-8436 x1234 مكتب Country Code +20
Area Code 2
Base Number 2464-8436
Extension 1234
Line Type مكتب
Additional Info  
Example 2 Input Output Token Output
02-2464-8436 في المساء Country Code  
Area Code 02
Base Number 2464-8436
Extension  
Line Type  
Additional Info في المساء
Example 3 Input Output Token Output
2337290-طنطا Country Code  
Area Code طنطا
Base Number 2337290
Extension  
Line Type  
Additional Info  
Example 4 Input Output Token Output
Home: (062) 787 9214 Country Code  
Area Code 062
Base Number 787 9214
Extension  
Line Type Home:
Additional Info  
Example 5 Input Output Token Output
+212-520-123456 Country Code +212
Area Code  
Base Number 520-123456
Extension  
Line Type  
Additional Info  
Remarks

NoteNote: To obtain optimal results, before performing data cleansing on phone numbers, the area code or governorate (which are often stored in databases separately from the base number) should first be concatenated with the base number.