Formulae: Using Contains Function?

nicci113 · May 15, 2013 4:58AM

IF(SEARCH("Brand",[Campaign]),"PET Brand"),
IF(SEARCH("pet",[Product],"PET Brand")

Sorry Guys, this contains function is really annoying and searching for alternatives, please suggest.

What I'm doing above is I'm searching Word "Brand" within campaign and "pet" within product and calliing it pet brand within another column,

Could anybody suggest how to make it work?

paola · May 15, 2013 5:37AM

Searching for one term:
IF(
CONTAINS([Field1], "word1"),
"value if TRUE" ,
"value if not")

If you wish to simultaneously search for 2 words/characters in one or 2 fields:

IF(AND(
CONTAINS([Field1], "word1"),
CONTAINS([Field2], "word2")),
"BOTH TRUE value" ,
"other")

nicci113 · May 15, 2013 6:40AM

Thanks Paola! you are a star :)

nicci113 · May 15, 2013 7:22AM

It's working ...

IF(AND(
CONTAINS([Campaign name], "BRAND"),
CONTAINS([Product], "pet")),
"Pet Brand" ,

AND(CONTAINS([Campaign name],"BRAND"),
CONTAINS([Product],"TRAVEL")),"TRAVEL",NULL)

No need for more than one "IF"....

nicci113 · May 15, 2013 10:34AM

My work doesn't like things to calm down so they now asked me to add one more rule into the already messed up. Now I want to build a rule where (BRAND) DOES-NOT-CONTAINS within Campaign name, rest remain the same.

Any suggestion which logic can be used. I read here
http://www.visokio.com/kb/subset-functions

but its a subset function which I do see in my formula list. please suggest

nicci113 · May 15, 2013 10:40AM

SUBSET([Campaign name], "BRAND", "does-not-contains")

This formula i am using and it doesn't seems to work

Welcome!

Categories

Ideas Parade

Tagged