This content has been marked as final. Show 3 replies
I need to filter a particular named txt files from the root folder (including all sub folders in it). I'm using the following sub routine and then filtering the sub routine result set to achieve the desired result.
for each FileExtension in 'txt'
for each FoundFile in filelist( Root & '\*.' & FileExtension)
LOAD '$(FoundFile)' as SourceFile,
FileTime( '$(FoundFile)' ) as Filetime
Set vConcatenate = Concatenate;
for each SubDirectory in dirlist( Root & '\*' )
Call ScanFolder ('myfolder\Log');
WHERE SourceFile LIKE '*Reload_Task_Check';
My question is it is possible to filter the name of the txt file inside the subroutine itself? Can you please help me here.