Regex_ Match for an Email Domain

Hi All,

I am relatively new to Alteryx and this is my first time trying to use regex.

My work flow allows the user to type in who they would like to email the produced tables to. I want to make sure that an error message is sent if they enter in any email address that does not end in "@gmail.com". I figured out how to have this happen when they enter one address (attached); however, if they enter multiple emails separated by a ";" the formula I have used doesn't check each address and wont display the error.

Based on lots of googling, it seems like I should be using a regex_match formula, but I am unsure how to write out what I am looking for in the "pattern" section. Any help is greatly appreciated!

Regex

Apps

Accepted answers

usmanbashir

@cbil -- Ahh that makes sense.

Can you try this? I tested out a few test cases as well as emails separated by semicolons, and they seem to work. I referenced from stackoverflow: https://stackoverflow.com/questions/56398660/regex-with-multiple-email-address-seperated-by-a-semi-colon

!REGEX_Match([email], '^(?>[\w+\-.%]+@gmail\.com(?:;\s*|$))+$')

All comments

usmanbashir

@cbil - try this. Hope this helps!

!REGEX_Match([email], '.*@gmail.com', 1)

Below are a few other options you can try. All tests are to show if email is not gmail. The '1' at the end of the formulas indicate case insensitive. You can decide which option might work best for you!

adamweaver39

Hi @cbil -- see two versions of that RegEx syntax, either in a formula or in the tool itself.

Let me know if that resolves your question, or if you need anything else.

Email match - RegEx tool.jpg Email match - RegEx formula.jpg

cbil

@adamweaver39and @usmanbashir

Thank you for your quick responses! I am dealing with multiple emails in one string separated by a semi colon. For example:

carli.conn@yahoo.com;larry.shu@gmail.com;carlconn@gmail.com

and I want it to be false if any of the emails do not use the gmail.com domain.

The answer you provided does not account for each email in the string.

cbil

Hi again - is there any way to edit the reg ex expression:

!REGEX_Match([#1], '^(?>[\w+\-.%]+@gmail\.com(?:;\s*|$))+$')

so that it doesn't throw the error message if the user does not enter any email at all.

For example, if the user is using the app just to generate the excels, but doesn't want to email them to anyone, I want them to be able to leave the email box blank and the workflow still run.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335