Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
below is my code:
let filepath = 'lib://faultData/*.xlsx';
For Each file in FileList(filepath)
Trace $(file);
if WildMatch(chr(39)&$(file)&chr(39), '*Incidents*')>0 then // i want to load only those files where file name consists of Incidents
// - its giving me error on the above wildmatch , in the error i can see inside the wildmatch the chr(39) is not getting converted to '
Trace $(file);
Incidents:
Load
*
From [$(file)]
(ooxml, embedded labels, table is sheet1);
EndIf;
Next;
it worked i just changed chr(39)&$(file)&chr(39) to '$(file)'
it worked i just changed chr(39)&$(file)&chr(39) to '$(file)'