Emptying a phone number

Last Updated : Sep 14, 2022 |

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.