topic Re: [resolved] tFileList-filemask-regular expression in Talend Studio

[resolved] tFileList-filemask-regular expression

sravanth49 — Mon, 15 Sep 2014 14:52:06 GMT

Hi,

can we include path as well in filemask.

I have some folders with .txt files. I wan't to read the file and insert data into database table. But I don't wan't to read files the from some folders,
like eg: if the folders has names lke test_rts,test2_old and 123456, I want to pick the files from 123456.

There are many folders, I want to pick the files from folder, which is named with numbered like 234567,986432 and folder name length should be 6 .

Thanks

Re: [resolved] tFileList-filemask-regular expression

Anonymous — Mon, 15 Sep 2014 15:15:29 GMT

Hi,
File is picked up from the path provided with the filter in the expression. If your folder name is dynamic and you want to iterate on folders then you need to identify a way to get the folder names may be something similar to below
tFixedFlow-->Iterate-->tFileList-->tFileInput-->youroutput...
Whether the metadata is same for all the files? If metadata is different, then you need to create different flows based on if clause and read those files based on certain condition.
Thanks
Vaibha

Re: [resolved] tFileList-filemask-regular expression

sravanth49 — Tue, 16 Sep 2014 09:14:37 GMT

Hi,
My folder structure is like this
d:/temp/
under above directory there are many sub-directories like AB,CD,EF
d:/temp/AB
d:/temp/CD
d:/temp/EF
under above directory there is a common folder named 'fest'
d:/temp/AB/fest
d:/temp/CD/fest
d:/temp/EF/fest
under above directory there are folders named like this '123456','234567','987654_gfds'
d:/temp/AB/fest/123456
d:/temp/AB/fest/234567
d:/temp/AB/fest/987654_gfds
There are .txt files from above directory, but I want to pick up from the folders '123456','234567'. I want to pick up .txt files from 6 digit folder.
Please do needful help.

Re: [resolved] tFileList-filemask-regular expression

Anonymous — Wed, 17 Sep 2014 11:11:57 GMT

Hi Sravanth,
Use "+.txt" as filemask in tFileList and select Includes Subdirectories option.
Screenshot for reference

Hope this will help you.

Re: [resolved] tFileList-filemask-regular expression

sravanth49 — Mon, 22 Sep 2014 09:39:09 GMT

Hi Gajwani,
It didn't work

Re: [resolved] tFileList-filemask-regular expression

Anonymous — Mon, 22 Sep 2014 10:46:30 GMT

Hi Sravanth,
My understanding mistake as i was working for files
please refer attached screenshot for reference in folder case

Hope this will help you

Re: [resolved] tFileList-filemask-regular expression

sravanth49 — Wed, 24 Sep 2014 09:18:49 GMT

Thanks Manish