Filter on folder name

[Anonymous]

Hello,
I would like to iterate through a folder list and retrieve only the files included in the folder name that are matching a certain name pattern.
I already spent so much time on tFileList, playing with the File mask and the Exclude FileMask. The thing is even if the mask is working, I cannot connect a tFileOutputDelimiter to tFileList because it includes folder name as well.
So I am searching for a way to, at the same time :
[list=*]

• Iterate through a folder list
  

• Filter on folder name (substring matching a part of the folder's name)
  

• Retrieve the XLS contained in the matching folders

Thank you so much
Arnaud

[vapukov]

Hi Arnaud,
What is Your problem? (please attach design)
on attached pictures - something similar what You explain, this Job sort statements from Years, Months subfolders
((String)globalMap.get("tFileList_2_CURRENT_FILEPATH")) - filename with full path
((String)globalMap.get("tFileList_2_CURRENT_FILE")) - file name only
I have many Jobs with different logic, so most of cases could be resolved (in some VERY HARD logic - You always can add Shell (tSystem, tSSH) step)
Best regards