JupyterLab Extension for INFACore

JupyterLab Extension for INFACore

Validate email address

Validate email address

You can apply this function to check if the email format in the data source is valid. The function does not check if the email is an active address.
To perform this operation, specify the data object variable, and then enter the column name that contains the email address that you want to validate.
When you run the code to validate the email format, the function returns values as valid or not valid.
For example, the input flat file includes a column named
email
that contains the email addresses that you want to validate.
The following snippet is the input code when you apply the function:
import informatica.infacore as ic FF_DV = ic.get_data_source("Flat File").get_connection("DR_FlatFile").get_data_object("input.csv") dqf = ic.DataQualityFunctions() dqf.validate_email_address(FF_DV,"email")
The following snippet shows the output returned with the validation values for the email address:
Email_Id: string Validation_Status: string ---- Email_Id: [["foobar@informatica.com","123","foobar"]] Validation_Status: [["Valid","Invalid","Invalid"]]

0 COMMENTS

We’d like to hear from you!