One Star

Regex expresssion within tfilter

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,
3 REPLIES

Re: Regex expresssion within tfilter

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.
One Star

Re: Regex expresssion within tfilter

Works perfectly - Thanks.
One Star

Re: Regex expresssion within tfilter

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.