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

Question

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?

laurathacker · Answer

Are the emails in a single field in separate records?&nbsp; Can you not use a Summary Report to look for records where the same email is used more than once?

anndeveloper_ · Answer

Figured it out...&nbsp;NotLeft([email],"@")works perfectly :)&nbsp;

Forum Discussion

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

2 Replies

Related Content

Filter records based on table connection

Using Groups

IF Statement based on a file being attached

Send Weekly Reminder Email based on Criteria

email notification error

Recent Discussions

'Is Set' in Pipelines

Share your feedback on the new Qrew Discussions

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Forms help

Empower Next Week!