6 Replies Latest reply on Sep 21, 2016 10:08 AM by Angie Tarbet

    can I filter on a data field that is all text (string) by writing a cal for key words?

    Angie Tarbet

      I have a data field which is seemingly the only option to use in order to filter out certain records. The field is all text, and varies in length and format (no standard count of characters). I have any of five keys words that I am looking for within the text along with one other word which must be present, along with one of the five other words.

       

      Is it possible to write a calculation which would search the text field for the key words and then display as True and if none of the words are present display as F?

       

      If anyone has any examples or suggestions, it is appreciated. I am unable to share the workbook, so hoping for examples or a How To type response if anyone is able. Thank you. Angie