check filename in an expression

bumin — Thu, 20 Oct 2011 20:46:24 GMT

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

bumin — Thu, 20 Oct 2011 21:18:51 GMT

I have enterred the followinh fomula:

=Match(sDir&docnum&'.JPG',FileFound)

but then I get each record twice

Bumin

topic check filename in an expression in QlikView