Description
The Split Email Address activity separates email addresses into two components:
- Local part: The portion before the
@ symbol (e.g., john.doe)
- Domain part: The portion after the
@ symbol (e.g., example.com)
This transformation is helpful when filtering, categorizing, or validating email data in bulk, enabling more targeted operations in workflows involving user data or email processing.
Use case:
You have a list of user emails and need to group them by email domain for organization-level analysis or to validate domains before sending bulk emails.
| Type | Description |
|---|
| Data | A dataset containing at least one column with valid email addresses. |
Output
| Type | Description |
|---|
| Data | Transformed data with the original email and the new local and domain columns. |
Configuration Fields
| Field Name | Description |
|---|
| Column Name | The column containing full email addresses to be split (e.g., email). |
| Local Part Column | The name of the new column where the portion before @ will be stored. |
| Domain Part Column | The name of the new column where the portion after @ will be stored. |
Make sure all values in the selected column are in standard email format (e.g., user@domain.com).
Sample Configuration
| Field | Value |
|---|
| Column Name | email |
| Local Part Column | local_part |
| Domain Part Column | domain_part |
Sample Output
This transformation simplifies downstream tasks like sorting emails by company domain, detecting invalid domains, or generating personalized email reports.