Filter on folder name

Anonymous — Tue, 14 Feb 2017 01:57:52 GMT

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

Re: Filter on folder name

vapukov — Tue, 14 Feb 2017 02:53:59 GMT

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

topic Filter on folder name in Talend Studio

Filter on folder name

Re: Filter on folder name