Validate phone number
The Validate phone number step allows you to validate phone numbers. The step understands the phone number formats and regional differences between phone numbers (like number of digits, prefixes, …) and will verify that the number follows the rules for selected region.
This step does not try to validate whether the number exists - it validates the format of the number only.
Parameters
-
Input column: required, a string column containing phone numbers with one number per row.
-
Region: select which region to use when validating the numbers. Region defines rules that the phone numbers must follow - for example, number of digits, prefixes, area codes and more. Typically, regions represent countries - like Unites States, Germany and many other. One special region - None - is provided in case you do not have any specific regional requirements for the numbers. This region requires phone numbers to have international dialing prefix (e.g., +1 etc.).
-
Accept empty: configure whether an empty value is considered a valid phone number. Empty value is a value that is either
null(shown as No value in data preview), zero-length string or a string composed entirely of whitespaces. By default, this is checked (i.e., empty values are considered valid).
Examples
| Input value | Accept empty values | Region | Result | Description |
|---|---|---|---|---|
|
Any |
US |
Valid |
Valid US phone number. |
|
Any |
US |
Valid |
Valid US phone number - whitespaces before and in the middle do not affect the validity of the number. |
|
Any |
US |
Valid |
Numbers with international dialing code (+44 - UK in this example) are valid even if specific region is selected (e.g., US). These numbers can be dialed from any country and if they match the local rules as defined by their dialing code, they are considered valid. |
No value |
Yes (checked) |
Any |
Valid |
This is valid number since Accept empty is checked. |
No value |
No (unchecked) |
Any |
Invalid |
Invalid since empty values are not allowed as per Accept empty setting. |
Remarks
-
Only syntax of the phone number is checked. The step does not try to verify that the phone number exists or is assigned to a user.
-
Running validation on an Error value does not try to validate the value and instead produces an Error right away.