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 (Electronic) | ||
|---|---|---|
| Description | The Phone (Electronic) standardization definition standardizes phone numbers for automated calling systems. | |
| Examples | Input | Output |
| (062) 787 9211 x123 مكتب ، في الصباح | +20627879211 | |
| (0)48 454 8783 | +20484548783 | |
| +961 01 218-757 | +9611218757 | |
| (101) 961 01 218-757 | +9611218757 | |
| 00961 01 218-757 | +9611218757 | |
| (02) 2464 8436 العمل | +20224648436 | |
| 7483119 الأسكندرية | +2037483119 | |
| Alexandria 7483119 | +2037483119 | |
| Alexandria (03) 748 3119 | +2037483119 | |
| 03الأسكندرية748 3119 | +2037483119 | |
| 2545 7930 | +20225457930 | |
| Remarks |
|
|
| The Phone (Electronic) standardization definition converts governorates to their corresponding numeric area code, and inserts area code 2 onto eight-digit numbers, as shown in the final five examples. | ||
|
Documentation Feedback: yourturn@sas.com |
Doc ID: QKBCI_AREGY_Std_Phone-Electronic.html |