This step parses email address fields and returns the username and domain for valid email addresses.
This step validates and parses email addresses as described by the International Network Working Group RFC 5322 Internet Message Format document.
An email address is an Internet identifier that contains a locally interpreted string followed by the at-sign character ("@", ASCII value 64) followed by an Internet domain. A valid email address is in the format user_name@domain.
Configure the step properties and output fields on two tabs.
- Step properties Selections on the Step properties tab specify behavior and output of this step.
- Output configuration Selections on the Output configuration tab define the output schema for the Parse Email step.
Step properties
Selections on the Step properties tab specify behavior and output of this step.
Step name
Defines the name for a step. Provide a meaningful name so that anyone who edits steps in a pipeline will be able to identify the purpose of a step.
Columns
Specifies email address columns in the dataset.
Output configuration
Selections on the Output configuration tab define the output schema for the Parse Email step.
This tab lists output fields defined by the Step properties settings. Clearing the check box next to a field name removes the corresponding field from the Step preview.
All of the fields displayed on this tab are initially selected by default. Clear the check box next to any field that you do not want to include in the step output. Select or clear the All fields check box at the top of the list to select or clear check boxes for all of the fields displayed on this tab.
You typically want to review selections on this tab after you edit settings on the Step properties tab. The fields displayed on this tab change as you configure settings on the Step properties tab. As you change settings on the Step properties tab, the number of selected fields and the total number of fields are displayed in parenthesis on the Output configuration tab label, for example, Output configuration (3 of 6).
Output fields
emailaddressfield_user_name
Returns the username portion of the email address.
emailaddressfield_domain
Returns the domain portion of the email address.
emailaddressfield_IsValid
The step sets this field to true if it successfully parsed a field
value into a username and a domain name. It is set to false if the
field value does not represent a valid email address.