3 Replies Latest reply: Feb 3, 2010 10:43 AM by Tony Wood RSS

    Selecting data from a qvd file using wildcards

    Tony Wood

      Hi,

      I have a need to select data from a QVD file based on the contents of an excel spreadsheet, the added complication is that I need to match only on part of the string, I can build the string from the spreadsheet ok.

      Example:

      // String build from Spreadsheet

      LET String="a like 'fre%' or a like 'ber%'"

      In SQL speak I could do

      select a, b, c
      from table
      where ($(String));

      Is there a way of doing it from a QVD file ?

      Thanks

      Tony