topic Re: tFileList exclude mask in Talend Studio

tFileList exclude mask

Anonymous — Sat, 16 Nov 2024 13:56:25 GMT

Hi, Is it possible to use more than one tFileList exclude mak and how could I do that if possible?

Re: tFileList exclude mask

Anonymous — Wed, 27 May 2009 16:57:35 GMT

Since the exclude fileMask is a regular expression, you can write your exclude filemask like this :

"(*.txt)|(*.pdf)|(*.doc)"

it should exclude txt, pdf and doc files (for example).
Note : I wrote a java regular expression, but the filemask is waiting for a Glob regular expression. Since I don't know theses expressions, I can't certify the syntax.

Re: tFileList exclude mask

Anonymous — Thu, 28 May 2009 08:45:15 GMT

Works perfectly, thanks a lot!
Edit: that was a little too fast, in fact it doesn't work! Thanks anywa for your help, but the topic is still opened

Re: tFileList exclude mask

Anonymous — Thu, 28 May 2009 23:43:58 GMT

I checked it : the idea was correct but not the syntax
Here is the good method with a java job :
1) uncheck the "use glob regular expression checkbox" (basic settings)
2) in "filemask", put a single line ".*" (the default "*" filemask does not compile when "glob expression" are desactivated). Of course, this pattern can be replaced by another (and by more than one line), but with a JAVA regular expressions (".+\\.wav" to allow the wav files, for example).
3) in "exclude filemask", this is the good syntax to exclude txt, doc and pdf files :

"(.+\\.txt)|(.+\\.pdf)|(.+\\.doc)"

I tested it in a real Talend job and it works.
If I have some time, I will modify the tFileList component to allow a list of glob exclude patterns (they are easier to write).

Re: tFileList exclude mask

Anonymous — Fri, 29 May 2009 08:18:58 GMT

Ok, thanks a lot and by the way, a list of glob exclude masks would be great!
Diane

Re: tFileList exclude mask

Anonymous — Thu, 04 Jun 2009 12:44:44 GMT

Ok, thanks a lot and by the way, a list of glob exclude masks would be great!
Diane

It's done !
You can try this component : https://community.talend.com/t5/Installing-and-Upgrading/Use-tFileInputXML-for-reading-process-lt-job-gt-item-xml-file/td-p/57542

Re: tFileList exclude mask

Anonymous — Fri, 19 Jun 2009 15:50:45 GMT

Great I didn't check my posts for a while, thanks a lot

Re: tFileList exclude mask

_AnonymousUser — Fri, 18 Apr 2014 10:22:50 GMT

I looked into the generated source code:

for (String excludefilemaskEach_tFileList_1 : excludefilemask_tFileList_1.split(",")) {}

It gives a hint for the correct glob exclude syntax:

"*.txt,*.pdf,*.doc"

Of course, I tested it and it works. 😉

Re: tFileList exclude mask

_AnonymousUser — Wed, 28 Jan 2015 10:39:27 GMT

Hi,
Thank, the good way to exclude file is with comma : "(myexcludedfile.*),(myotherexcludedfile.*)"

Re: tFileList exclude mask

Anonymous — Tue, 06 Dec 2016 15:09:37 GMT

You dont need the brackets "(" around it. This works:
"000*,001*"