2 Replies Latest reply: Oct 20, 2015 12:22 PM by Jared Papador RSS

    Filelist check for just xls and exlude xlsx

    Jared Papador

      I have written a loop that checks a directory for xls files:

       

      FOR EACH File in FileList('\\SharedDrive\Production\Qlikview\Rebate Data\*.xls')

      LET  vXLSExists = 1;

      exit for when $(vXLSExists) = 1;

      NEXT File;

       

      Works great.  The problem is there are NO .xls files in that directory.  There are a bunch of .xlsx files.  I know the QlikView help says that .xls in a filelist is essentially .xls*.

       

      Is there anyway to change it to only search for .xls?