Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Using Contains Function? - Visokio Forums
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?
  • 5 Comments
  •     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!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership