Split Email Address
Infoveave Data Automation — Text & String
One email column becomes two — local part before the at sign and domain after — ready for domain-level segmentation and company attribution.
Email addresses contain two pieces of information joined by the at sign — the local part identifying the individual user and the domain identifying the organization or provider. Keeping both parts in a single column makes it impossible to group contacts by company domain, filter for specific email providers, validate domains against an allowed list, or segment analysis by organizational affiliation. Split Email Address separates the two components automatically, adding named local part and domain part columns to every row. Domain-level analysis, organization attribution, and bulk email hygiene become straightforward downstream operations rather than text parsing exercises.
What Split Email Address does
Split email address columns into local part and domain part in Infoveave. Separate the username from the domain for domain-level analysis, organization segmentation, and email validation workflows.
When to use Split Email Address
- You have a list of contacts or users with email addresses and need to group, filter, or segment them by email domain — for example identifying all contacts at a specific company
- You are building an email hygiene or validation workflow and need to check domain values against an allowed or blocked list separately from the local part
- You want to attribute leads, customers, or users to organizations based on their email domain as a proxy for company affiliation
- You need the local part of the email address separately — for example to generate personalized display names or to compare username patterns across contacts
When to avoid it
- Your column contains URL strings rather than email addresses — use Split URL for URL-specific parsing into protocol, host, path, and query components
- Your column contains arbitrary text that happens to include some email addresses alongside other content — use Find Text with a regex pattern to extract the email address string first, then apply Split Email Address
- You need to validate the full email address including format structure — use Find Text or a Filter on Bad Meaning step with a regex validation pattern before splitting
Where it fits in your Infoveave automation
Split Email Address is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Split Email Address
Real scenarios where this transformation saves hours of manual work.
Segment CRM Leads by Company Domain for Account-Based Attribution
A B2B SaaS marketing team processes CRM lead records where each lead has an email column. Split Email Address extracts the domain from every lead email, adding a domain_part column. The team groups leads by domain to identify the companies generating the most inquiry activity, attribute marketing campaign performance to specific company accounts, and prioritize outbound follow-up based on domain-level engagement signals.
Validate Customer Email Domains Against Allowed Business Domains
A financial services compliance team processes new customer applications where each application record includes an email contact field. Split Email Address extracts the domain part into a separate column. The compliance team then filters the domain column against an allowed list of verified business domains, flagging applications with personal email provider domains — gmail, yahoo, hotmail — for additional identity verification before account activation.
Analyze Email Engagement by Provider Domain for Deliverability
An email marketing team processes campaign engagement data where each record includes the recipient email address. Split Email Address extracts the domain part into a dedicated column. The team aggregates open rates, click rates, and bounce rates by email domain, identifying which provider domains have the highest deliverability challenges. Domain-level deliverability analysis guides warming strategies and suppression list updates.
See Split Email Address in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
emaillocal_partdomain_partInput Data
| ID | Name | |
|---|---|---|
| 1 | Alice Smith | [email protected] |
| 2 | Bob Brown | [email protected] |
| 3 | Charlie Lee | [email protected] |
| 4 | Daisy Adams | [email protected] |
Output Data
| ID | Name | local_part | domain_part | |
|---|---|---|---|---|
| 1 | Alice Smith | [email protected] | alice.smith | example.com |
| 2 | Bob Brown | [email protected] | bob.brown | sample.org |
| 3 | Charlie Lee | [email protected] | charlie.lee | test.edu |
| 4 | Daisy Adams | [email protected] | daisy.adams | company.com |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Name
Select the column that contains the email address strings to parse. All values in this column are expected to follow standard email format with exactly one at sign separating the local and domain parts. Rows containing malformed values without an at sign may produce empty or unexpected values in the output columns.
Local Part Column
Specify the name for the new column that will hold the portion of the email address before the at sign. This is typically the username or individual identifier part — for example alice.smith from [email protected].
Domain Part Column
Specify the name for the new column that will hold the portion of the email address after the at sign. This is the domain name that identifies the email provider or organization — for example example.com from [email protected].
Frequently asked questions
Everything you need to know about Split Email Address in Infoveave.
Also in Text & String — and what runs before & after
Transformations in the same family as Split Email Address, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Split Email Address is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
