Skip to main content
Question

how can I group a list of emails based on the text AFTER @?


I am wanting to group a list of emails to check for duplicates. My thinking was I could do a formula field that strips out the @domain.com part of the email and then group that way. Would that be the correct way to do this?
This topic has been closed for replies.

Forum|alt.badge.img+14
Are the emails in a single field in separate records?  Can you not use a Summary Report to look for records where the same email is used more than once?

Figured it out... NotLeft([email],"@")

works perfectly :)