7 Replies Latest reply: Oct 12, 2012 9:18 AM by Dariusz Szul RSS

    filter out records based on keywords

      Hi,

       

      I have a table where one of the fields is called Keywords

      e.g Keywords:

           "good book"

           "bad book"

            "www.book.com"

            "buy great books"

           "medical Books"

           "reading medical"

             etc.

       

      I would like to filter out all records where field Keywords doesn't contain word "book" (either lower case or upper case). So the expected result would be all the above keywords except "reading medical". What function do I use for it? How would the code look like?

       

      I am a beginner with QV and coding so please help me to write the code for it.

       

      Thanks