Hello everybody : )
Does anybody know how to extract only the domain from an email adress with the formatter ?
Like the following :
“me@company.com” → “company”
Thanks a lot 
Best answer
Extract domain from email adress with formatter
Best answer by luke.johnson
Hi
For a more complex extraction like this, you can use the Formatter’s “Extract Pattern” transform option. This allows you to provide a Regular Expression to find a match. Regular Expressions can look pretty intimidating, but I believe the following the pattern should achieve what you’re looking for:
(?<=@)[^.]*.[^.]*(?=\.)
This would produce the following output:
Let me know if this helps or if you have any other questions!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Formatter > Text > Split (@) and keep the last segment.
- Zapier Staff
- Answer
Hi
For a more complex extraction like this, you can use the Formatter’s “Extract Pattern” transform option. This allows you to provide a Regular Expression to find a match. Regular Expressions can look pretty intimidating, but I believe the following the pattern should achieve what you’re looking for:
(?<=@)[^.]*.[^.]*(?=\.)
This would produce the following output:
Let me know if this helps or if you have any other questions!
- Zapier Staff
Hi
Formatter > Text > Split (@) and keep the last segment.
This will keep “.com” in the output, but it’s definitely a simpler solution if that isn’t an issue!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.