10 Replies Latest reply: Apr 28, 2015 4:17 PM by Andii Toole RSS

    How do I eliminate data with a certain string of characters?

      Hi,

       

      I have a certain amount of information associated to OrderID's - which are all numeric. However, we have test orders in the system (a lot of them) that all start with 'F'.

       

      I want to try and eliminate these dummy orders and their associated information - but I'm not sure how to write that into the script. in SQL, I use the like function with a wildcard - but it looks like the wildmatch function in Qlikview doesn't duplicate this exactly.

       

      Any suggestions?

       

      Example:

      DUMMY DATA        REAL ORDERID

           F653519                    1089136