9 Replies Latest reply: Jul 21, 2015 10:23 AM by arjun rao RSS

    wildmatch

      The goal is to find the rows including the values in NAME,

      the wildmatch don't work in this case, please help me to correct it? Thank you very much!

       

      TN:

      LOAD

          NAME

      FROM

      [C:\Users\adsli01\Documents\2015-05-20 Extraction pour le SAR\GROUPE-NAME.qvd]

      (qvd)

      WHERE len(NOM_GROUPE) = 0;

         

      let i = 1;

      //set iend = 50000; //NoOfrows(TN);

      do while i <= 50000

          let NCom = '*' & peek(NAME, $(i), 'TN') & '*';

          T:

          load Distinct

          NOM_GROUPE,

          REF_GROUPE

          FROM

          [C:\Users\adsli01\Documents\2015-05-20 Extraction pour le SAR\GROUPE-Help.qvd]

          (qvd)

          where wildmatch(NOM_GROUPE, $(NCom) )=1

          ;   

          let i = i+1    ;

      loop

      ;