File with format

[Anonymous]

If I have list of Qvd in the format Sale_201603.qvd ,Sale_201709.qvd and Sale_UAT_201702.qvd ,Sale_201709-Copy.qvd and

How I can pick all the files with Sale_YYYYMM format only

[MindaugasBacius]

I think From path\Sale_2* might work

[avinashelite]

Try like this

Path\Sale_*.QVD will load all the files which starts with Sales_

or

Path\Sale_2*.QVD

[jonathandienst]

Perhaps

Path\Sale_??????.QVD

or test explicitly for numeric values in the YYYYMM portion:

For Each vFile in FileList('Path\Sale_*.qvd')

  Let vTestStr = TextBetween(vFile, '\Sale_', '.qvd');

  Let vTest = IsNum(vTestStr) and Len(vTestStr) = 6;

  if vTest Then

     LOAD *

    FROM [$(vFile)]

    (....)

  End If

Next