Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

How to clean email addresses?

8 - Asteroid


I have asked for some help last week about email addresses and CharlieS gave me a Regex formula that covers 85% of the syntax errors I could meet. 


here is the great Regex formula



However it rejects some email addresses which are correct


(i) Some emails have two dots in their domain name or a dash, which are both accepted. 



(ii) Some emails have been set as FALSE for some reasons I do not understand‬‬  (digits in the domain name?)

Woelk& (ampersand is allowed in email syntax)


do you know how I can get them set as correct addresses? 

thank you 


15 - Aurora

There are some sites with lists of RegEx's to try, notably and could try some of those to see if they include more valid ones.  Lots of good discussion at StackOverflow also.


8 - Asteroid

thank you John! I visited the sites: I know what my day will be like tomorrow!! 

thank you


11 - Bolide

What did you end up going with? I've been using this REGEX_Match([Email_address_1], '.+@.+\..+') but it lets through emails with spaces in them which I could remove but I recently read that spaces can be allowed in an email address in some instances. But doesn't allow them when I send them data. I wonder what their validation process is based on. 


I found myself in a rabbit hole on the StackOverflow discussion and then Dominic Sayers blog seemed pretty good but then how to incorporate his PHP program into Alteryx work flow... Anyway curious where you ended up with your email syntax validation. I was just looking for basic syntax check to remove things like noemail and NA and all that when I started this project.