Note: 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.
SAS Quality Knowledge Base for Contact Information 27
| Phone | ||
|---|---|---|
| Description | The Phone standardization definition standardizes phone numbers for domestic use. | |
| Examples | Input | Output |
| +20 (0)48 454 8783 | (048) 454 8783 | |
| +961 01 218-757 | +961 1218757 | |
| (02) 2464 8436 العمل | (02) 2464 8436, العمل | |
| 7483119 الأسكندرية | (03) 748 3119 | |
| Alexandria 7483119 | (03) 748 3119 | |
| Alexandria (03) 748 3119 | (03) 748 3119 | |
| 03الأسكندرية748 3119 | (03) 748 3119 | |
| 2545 7930 | (02) 2545 7930 | |
| Work: (02) 2464 8436 | (02) 2464 8436, العمل | |
| Remarks |
|
|
| The Phone standardization definition converts governorates to their corresponding numeric area code, inserts the area code 02 onto eight-digit numbers, and translates English line type phrases to Arabic, as shown in the final six examples. | ||
|
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_AREGY_Std_Phone.html |