topic Regex expresssion within tfilter in Talend Studio

Regex expresssion within tfilter

Anonymous — Sat, 16 Nov 2024 14:06:30 GMT

Hi,
How can I implement a java regex expression into a tfilter for an input field :-
\d{4}\-\d{3}T\d{2}\:\d{2}\:\d{2}\.\d{3}
I have seen similar questions in the forum but not answers.
Thanks in advance,

Re: Regex expresssion within tfilter

Anonymous — Wed, 07 Jan 2009 19:53:57 GMT

In the tFilterRow component, check the "use advanced mode" checkbox.
This should allow you to input custom code to filter rows.
you can do something like

input_row.columnName1.matches("\d{4}\-\d{3}T\d{2}\:\d{2}\:\d{2}\.\d{3}");

I hope this helps.

Re: Regex expresssion within tfilter

Anonymous — Wed, 07 Jan 2009 21:25:20 GMT

Works perfectly - Thanks.

Re: Regex expresssion within tfilter

fyk_cz — Thu, 08 Jan 2009 16:12:07 GMT

In "simple" (not advanced mode) add a column for filter, select Match in Function list and type a regex expression in Value area. You must double a backslashes in regex string and don't forget doublequotes.