7 Replies Latest reply on Jun 24, 2010 11:08 AM by comment_1

    Should I be using a Filter function here?

    firth5

      Title

      Should I be using a Filter function here?

      Post

      FIELD1 uses a checkbox value list.   Several lines of text might therefore be entered in the field.

       

      I"m trying to create a calc field that will look at FIELD1, and scan the the field for "Example Phrase".  If the phrase is anwhere in the field, it gives me True result, otherwise it gives me a False result.

       

      What function do I use to examine FIELD1?

       

      I tried using the FILTER function, as in the following, but it only works if there is the only text in FIELD1 is "Example Phrase."  What did I do wrong, or is there a simpler function?

       

      If (FIELD1 = Filter(FIELD1 ;"Example Phrase") ; "True" ; "False")