Task
A table contains email addresses, and another system needs only the domain part: for example, example.test instead of Buyer@Example.TEST.
Short answer
In the final domain column, use email as the source and apply three rules: remove before @, remove @, then lowercase.
What matters for the result
- Keep
Lowercaseas the last rule when emails may contain uppercase letters. - For rows without
@, add an export condition or leave the domain empty to avoid garbage values. - If one cell contains several emails, decide whether you need the first address or all addresses as separate rows.
Before / After
Before
source data| id | |
|---|---|
| 1001 | Buyer@Example.TEST |
| 1002 | sales@Store.FR |
After
result| id | domain |
|---|---|
| 1001 | example.test |
| 1002 | store.fr |
Where to Open Settings
Open the settings under domain; the source column isemail.
How to Do It in Eofferix
- Add a transformation: condition Contains substring, value
@, action Remove before.
After this rule the value becomes @Example.TEST. - Add the next rule: condition Contains substring, value
@, action Remove substring.
This leaves only the domain text. - Add the final rule: condition Any, action Lowercase.
The final domain is normalized to lowercase, for example Example.TESTbecomesexample.test. - Save the column settings, save the template, then on the final step run the transformation.