Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think From path\Sale_2* might work
Try like this
Path\Sale_*.QVD will load all the files which starts with Sales_
or
Path\Sale_2*.QVD
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