3 Replies Latest reply on Dec 28, 2016 1:51 PM by Barb Reiser

    Find Multiple Substrings within Text String

    Barb Reiser

      Hi all,

       

       

      I would like to display all keywords in a string of text. With the formula below, it only will display 1 keyword even if 2 are in the string. How to do I allow all keywords to show?

       

      IF CONTAINS([Do you have any comments],"Blood") = true THEN

          "Blood"

      ELSEIF CONTAINS([Do you have any comments],"mold") = true THEN

          "mold"

      ELSEIF CONTAINS([Do you have any comments],"smell") = true THEN

          "smell"

      ELSEIF CONTAINS([Do you have any comments],"dirty") = true THEN

          "dirty"

      ELSE

          Null

      END

       

       

      Thank you,

      Barb