Validate email
The Validate email step allows you to validate syntax of an email address. The step only verifies the syntax of the email address - for example, that it has proper local and domain names, that it contains the "@" symbol etc. This step does not try to send an email to verify the existence of the email address.
Parameters
-
Input column: required, a string column containing email addresses with one address per row.
-
Accept empty values: configure whether an empty value is considered a valid email. 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 emails are considered valid).
Examples
| Input value | Accept empty values | Result | Description |
|---|---|---|---|
|
any |
Valid |
A valid email. |
any |
Valid |
The step strips out leading and trailing whitespaces before validation so this is a valid email. |
|
|
any |
Invalid |
Email address cannot contain whitespaces in the middle - these are not removed during the validation. |
|
any |
Invalid |
An invalid email missing the domain part. |
No value |
Yes (checked) |
Valid |
This is valid email since Accept empty values is checked. |
No value |
No (unchecked) |
Invalid |
Invalid since empty values are not allowed as per Accept empty values setting. |
Remarks
-
The step only validates syntax of the email. It does not verify that the email (or even its domain) exists.
-
Running validation on an Error value does not try to validate the value and instead produces an Error right away.