9 Replies Latest reply: Jul 25, 2016 5:38 PM by Kannan Sundaram RSS

    How can we do Word Boundary Match in Qlikview?

    Kannan Sundaram

      I have a following query in SQL server:

      SELECT * FROM TABLE_A

      DESCRIPTION NOT LIKE '%[^a-z]cos[^a-z]%'


      So this query will return values only if it has the text COS as a whole, without any characters [a-z] before or after that.

      If I use WILDMATCH ( DESCRIPTION, '*COS*'), it returns rows that have have words like 'ECOSYSTEM' which has characters [a-z] before and after. This is not desirable.


         

      DESCRIPTIONSQL SERVERQV WILDMATCH
      Abcde COSTRUETRUE
      defgh COSTRUETRUE
      EcosystemFALSETRUE
      TotalcostFALSETRUE
      SumofCostFALSETRUE



      So my question is what is the correct function or method in qlikview that will return exact same result as the SQL SERVER query I have above.


      Thanks,

      KS