In the Data Quality Configure section, map the email address to clean up email addresses with an invalid format.
- This task will correct email format and invalid suffix.
- This task does not validate the email is a working email.
- This task does not validate the email address against any known email database.
- An email address that cannot be reformatted will be copied in its original form.
- If an email address has no suffix at all, the task will add ".com" to the end of the email.
Example:
The following examples of bad email addresses will correct to dole@openprisetech.com using this task:
- dole@openprisetech.con (invalid suffix)
- dole@openprisetech,com (comma or other special characters before the suffix)
- dole@openprisetechcom (missing dot before suffix)
- dole@openprisetech (missing suffix)
- dole@openprisetech..com (more than one .)
- dole@@openprisetech.com (more than one @)
- dole(at)openprisetech.com (use of (at) instead of @)
Remember to click Save to save to your project.