Skip to main content
Question

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

  • July 17, 2019
  • 0 replies
  • 31 views
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+12
    • LauraThacker
    • Registered
    • July 17, 2019
    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?
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    • AnnDeveloper
    • Author
    • Registered
    • July 17, 2019
    Figured it out... NotLeft([email],"@")

    works perfectly :) 
    Terms & ConditionsAccessibility statement