SAS Quality Knowledge Base for Contact Information 27

Phone (Multiple Number)

Parse Definition

Phone (Multiple Number)
Description The Phone (Multiple Number) parse definition parses multiple phone number format input into a set of tokens.
Output Tokens Phone 1
Phone 2
Example 1 Input Output Token Output
0107902881/010750788 Phone 1 0107902881
Phone 2 010750788
Example 2 Input Output Token Output
0114698116-27162079 Phone 1 0114698116
Phone 2 27162079
Example 3 Input Output Token Output
0121176617,37833437 Phone 1 0121176617
Phone 2 37833437
Example 4 Input Output Token Output
011/1005002 Phone 1 011/1005002
Phone 2  
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.

 

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: QKBCI_AREGY_Parse_Phone-MultiNum.html