Is there a way to look for just a subset or even the entire word within an email address and for the contains function to catch it as true? For example, NameEmail addressCalifornia Kingabcd@CaliforniaWest.comSuper Martabcd@Supermercado.com Chicken shackabcd@chickplace.com California Kingabcd@smallking.com In each of these incidents I want it to detect as true since line 1 has "California", line 2 contains "Super", line 3 contains "chick", and line 4 has "king" contained in the email address.

How to do contains function for multiple words contained within an email address?

Is there a way to look for just a subset or even the entire word within an email address and for the contains function to catch it as true?

For example,

Name	Email address
California King	abcd@CaliforniaWest.com
Super Mart	abcd@Supermercado.com
Chicken shack	abcd@chickplace.com
California King	abcd@smallking.com

In each of these incidents I want it to detect as true since line 1 has "California", line 2 contains "Super", line 3 contains "chick", and line 4 has "king" contained in the email address.

Developer Tools

Common Use Cases

Preparation

Accepted answers

All comments

philipmannering

Perhaps something like this...?

Contains word in phrase.yxmd

JosephSerpis

Hi @dkim4 you would need to use a contain formula I have mocked up this example

Contains_300819.yxmd

dkim4

I forgot to add that I have thousands of rows. This would be a very tedious process if I were to add thousands for formulas.

Any alternatives?

Hicham_Alteryx

I need an Alteryx formula something like this IF CONTAINS([FT_FDBCK_TOP_REG_CAT_TYPE_TX],"American","ADA","Deaf","Disable","blind") then 1 else 0 endif

But the the Contains function only allows for one word... is there a formula where you can list as many words as you would like to return if it's true or false. Thank you!

Ben_H

Hi @Hicham_Alteryx,

You might want to create a new thread for your question to make sure it gets answered.

Regards,

Ben

Christina_H

Try using RegEx. For the example in the main thread: REGEX_Match([Email address], ".*(California|super|chick|king).*")

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703