Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Testing for Valid Email Address?

djspring
6 - Meteoroid

Hi,

 

Does anyone know an easy way to test if a portion of an email address is valid?

 

I only want to test everything after the @ symbol.    Ex.melissa.jones@rainbowcloud.com

 

Thanks!

3 REPLIES 3
afv2688
16 - Nebula
16 - Nebula

Hello @djspring,

 

You can test if the email address has the following format

 

name@whatever.com

 

Meaning that you cannot really test if the domain is a realy one.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

fmvizcaino
17 - Castor
17 - Castor

Hi @djspring ,

 

Attached is an example built with Regex showing how to check for the @anything.com structure, including a way of separating the domain if you want to compare with a dataset of known domains, for instance.

 

Let me know if this works for you.

Best,

Fernando Vizcaino

djspring
6 - Meteoroid

Thanks so much.  I was able to get the results I needed.

 

Much appreciated!

Labels
Top Solution Authors