Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to check is a filename exists in a directory
depending on it I want to show the filename in a diagram
within the script I have found all JPG-Files
LET sDir = 'C:\Users\bumin\pictures\'; // Directory to look through
LET sFile = '*.JPG'; // Searchpattern
LET sSearchPattern = sDir & sFile;
// =================== Scan through directory and list all possible files
FOR EACH vFile in FileList (sSearchPattern)
FilesFound:
LOAD
'$(vFile)' AS FileFound
AUTOGENERATE 1;
NEXT vFile
now I want to check if a spcific filename does exists in FileFound
I have tried several functions but I didn' got it.
can someone help?
thanks
Bumin
I have enterred the followinh fomula:
=Match(sDir&docnum&'.JPG',FileFound)
but then I get each record twice
Bumin