How to clean long list of email addresses?

msantoso

Hi everyone,

I need to review a 30K-record customer file with email addresses. 

I can see many repeated mistakes, such as 

- more than one '@' in an address

- 2 email addresses separated with a comma or a semicolon

- no suffix (.com )

etc. 

Is there a way to highlight all the addresses that do not follow a specific syntax such as

 [any_character_or_digit]@[any_character_or_digit][dot][a max of 3 characters]

If anyone has ever done this job, I'd be happy to learn from her/his experience.

thank you

Myriam

CharlieS

Here's an updated RegEx formula to use::

([\w.-]+\@[\w.-]+\.\w{2,3})

Replacing '\w+' with '[\w.-]+' Allows '.' and '-' characters to be included with alphanumeric characters. The '{2,3}' means the domain can be either 2 or 3 characters long.