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 by luke.johnson
View originalHello 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 by luke.johnson
View originalHi
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!
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.