topic Re: Regex in tFileList component in Talend Studio

Regex in tFileList component

param123 — Mon, 02 May 2022 12:06:56 GMT

Hi Team,

Can someone suggest, how to use regex expression in tFilelist component.

use case: i want to achive below...my tFilelist component must be able to identify below pattern files

1) file_501.txt

2) file_075.txt

I tried writing pattern as file_[(501)|(075)].txt, but didnt work.

Re: Regex in tFileList component

gjeremy1617088143 — Mon, 02 May 2022 12:25:39 GMT

Hi @chiranjeevi kalla , in tFileList you can add multiple masks. so make one for file_501.txt and another for file_075.txt.

Send me love and kudos

Re: Regex in tFileList component

param123 — Mon, 02 May 2022 12:39:30 GMT

@guenneguez jeremy , thanks for your response, I don't want to do it in that way, if in future i want to make a new file pattern entry i should touch the code again. i want to do it via single regex expression, so that i can contextualise and edit from backend. please let me know if you know a way how to achieve at single shot by writing regex

Re: Regex in tFileList component

gjeremy1617088143 — Mon, 02 May 2022 13:34:34 GMT

so uncheck the checkbox use globlal expression and you can use perl5 regex :

"file_(501|075).txt"

Re: Regex in tFileList component

param123 — Wed, 04 May 2022 10:24:28 GMT

hi @guenneguez jeremy tried above, not picking any files...

Re: Regex in tFileList component

gjeremy1617088143 — Wed, 04 May 2022 12:16:11 GMT

i've tested it on TOS 7.3.1 and it's working, checkbox use global expression unchecked and "file_(501|075).txt" in the expression field

Re: Regex in tFileList component

param123 — Wed, 04 May 2022 13:43:52 GMT

HI @guenneguez jeremy , please check below design I am not able to achieve , please let me know if something wrong in the design or please share your design

Re: Regex in tFileList component

gjeremy1617088143 — Wed, 04 May 2022 15:43:11 GMT

could you send the content of the tJava?

Re: Regex in tFileList component

param123 — Wed, 04 May 2022 15:48:04 GMT

hi, @guenneguez jeremy I am just printing the file name thats it...its not picking anything

Re: Regex in tFileList component

param123 — Mon, 09 May 2022 07:14:20 GMT

Hi Talend team,

can someone help on this query?

Re: Regex in tFileList component

gjeremy1617088143 — Mon, 09 May 2022 07:31:52 GMT