Emptying a phone number

Last Updated : Sep 14, 2022 |
Prolog information
Metadata
Keywords:
If the phone number attribute contains numeric and non–numeric values, you can configure POM to remove only the non–numeric characters from the phone number attributes. As a result, POM does not reject the entire contact during import.
This is applicable based on the defined Reject Patterns and Phone formats rule.
POM does not clean up the country code if the country code is provided as a separate attribute. If POM finds non-numeric characters in the country code attribute except the leading single +(plus) or –(minus) sign, POM rejects the contact as per the existing behavior.
However, if the country code is not provided as a separate attribute, but is provided in the phone number attribute and separated from the phone number by the country code separator, POM cleans up the non-numeric characters from the country code that is extracted out of the phone number attribute.
Considering # as the country code separator, POM displays the following behavior:
Phone Number Input
Country code input
Phone Number Output
E-mail address
Rational
Record Inserted/Rejected
(541) 754-3010
5417543010
Non-numeric characters removed
Inserted
(541)754$3+0+1-0
5417543010
Non-numeric characters removed
Inserted
1#514-204-40392
51420440392
1 will be considered as country code as it appears before the separator
Inserted
6-1#514-204-40392
51420440392
61 will be treated as Country code, it will be cleaned. Rest will be treated as phone number, it too will be cleaned
Inserted
6-1#514#204#403-92
51420440392
Values before the first appearance of the country code will be treated as country code, it will be cleaned. Rest will be treated as phone number, it too will be cleaned
Inserted
9+1#212#121
91
91212121
As country code is provided separately, entire phone number is cleaned up and numeric digits will be considered as phone number although it has country code separator
Inserted
9+1#212#121
9+abcd+1
<empty>
As country code is provided separately, and it contains non-numeric characters, the entire record will be rejected
Rejected
9121212199999999
91
<empty>
shamik@pomemail.com
Phone number made empty as it matches phone format rule. But email is valid, so record is accepted
Inserted
9121212199999999
91
<empty>
abcdefghijk
Phone number made empty as it matches phone format rule. Email is also invalid. So record will be rejected
Rejected
9+1#212#121
9+abcd+1
<empty>
shamik@pomemail.com
Although email is valid, but since country code is invalid, the record is rejected. This is as per existing behavior, that is, if any other attribute is invalid (including country code provided separately), the record is rejected
Rejected
POM rejects the entire record if all phone number attributes and email addresses are evaluated to be invalid, based on selection of the configurations in the table above.
If POM evaluates any phone number or email address as valid, POM accepts the record.