1 Reply Latest reply: Apr 26, 2018 6:39 AM by abhishek singh RSS

    why this wildmatch is not working in file name comparision ?

    abhishek singh

      below is my code:

      let filepath = 'lib://faultData/*.xlsx';

       

      For Each file in FileList(filepath)

      Trace $(file);

        if WildMatch(chr(39)&$(file)&chr(39), '*Incidents*')>0 then // i want to load only those files where file name consists of Incidents

        // - its giving me error on the above wildmatch , in the error i can see inside the wildmatch the chr(39) is not getting converted to '

          Trace $(file);

      Incidents:

      Load

      *

              From [$(file)]

              (ooxml, embedded labels, table is sheet1);

           EndIf;

      Next;