topic Re: Match Regular expression with tFilterRow in Talend Studio

Match Regular expression with tFilterRow

_AnonymousUser — Sat, 16 Nov 2024 14:17:30 GMT

Hi
I tried to use advanced settings of tFilterRow to filter dataflow with regexp, but lacking java knowledge stopped me
Could someone paste a sample java code for matching with regexp?
Thanks in advance

Re: Match Regular expression with tFilterRow

_AnonymousUser — Mon, 19 Jul 2010 15:00:13 GMT

I have a similar question to Ruben, I need to have regex expressions in tFilterRow to filter out invalid data type entries from a CSV file.
Thanks for your help.
Zohaib

Re: Match Regular expression with tFilterRow

Anonymous — Mon, 19 Jul 2010 15:44:02 GMT

hi all,
Have a look at api java regex for matches method !
hope it help
laurent

Re: Match Regular expression with tFilterRow

_AnonymousUser — Mon, 19 Jul 2010 18:41:10 GMT

Kzone,
I'm a newbie to Talend. Could you please let me know where can I write the code that you suggested for the CLASS.
An screenshot or a sample would be of great help.
Thanks a lot,
Zohaib

Re: Match Regular expression with tFilterRow

Anonymous — Mon, 19 Jul 2010 21:23:43 GMT

hi Zohaib,
in fact it's pretty simple.
For example let's match for compliance mail ! (a classic).
In the 'advanced mode' write your condition with the convinience method matches. it does the work for you
first arg : your regular expression
second arg : string to be parse
the method return boolean
For 'true' goes into filter flow ; when 'false' goes into reject flow.
Right, in my example all email are correct; made one wrong and it goes in reject ...
now you have to write your regex
hope it help
regards
laurent

Re: Match Regular expression with tFilterRow

_AnonymousUser — Mon, 19 Jul 2010 21:29:06 GMT

Thanks Kzone!

Re: Match Regular expression with tFilterRow

Anonymous — Mon, 19 Jul 2010 21:30:36 GMT

you welcome

Re: Match Regular expression with tFilterRow

_AnonymousUser — Fri, 02 Sep 2011 03:51:24 GMT

Hi I am wondering how to ignore or filter out some data from Input file.
I have columns with no data. and they need to be filtered in the out put file.
How to use TFilterRow ?

Re: Match Regular expression with tFilterRow

Anonymous — Fri, 02 Sep 2011 05:08:25 GMT

Hi I am wondering how to ignore or filter out some data from Input file.
I have columns with no data. and they need to be filtered in the out put file.
How to use TFilterRow ?

Yes, tFilterRow or tMap component can used to do the filter.
Best regards
Shong

Re: Match Regular expression with tFilterRow

_AnonymousUser — Tue, 03 Jan 2012 13:20:07 GMT

Hi ,
I tried to use the advance mode in the tFilterRow to use a regex .
here is the regex : input_row.etab.matches("\"12206\"|\"12906\"|\"16006\"") (i also tried without the \ )
heres is the data I wont to filter :12206 - CR22
12906 - CR29
13306 - CRAQ
13606 - CRIV
14445 - CEBPL
14706 - CRAV
16006 - CR56
16275 - CENFE
17906 - CRAM
18025 - CEPIC
19406 - CRTP

at the end i should have the row with
12206 12906 et 16006.
Instead I got nothing .
What did I miss ??
PS , I also tried : java.util.regex.Pattern.matches("12206|12906|16006", input_row.etab) and got the same results.

Re: Match Regular expression with tFilterRow

_AnonymousUser — Tue, 03 Jan 2012 14:22:22 GMT

Here is the solution.
It seems the v5 can not handle expression like "12206|12906|16006" or even ("\"12206\"|\"12906\"|\"16006\"") in the basic condition.
Using advance mode does not work either for things input_row.etab.matches("12206|12906|16006")
So I used java.util.regex.Pattern.compile("12206|12906|16006").matcher(input_row.etab).find() to filter my data .
And this time it works .
Hope this help, someone else .
Happy new year .

Hi ,
I tried to use the advance mode in the tFilterRow to use a regex .
here is the regex : input_row.etab.matches("\"12206\"|\"12906\"|\"16006\"") (i also tried without the \ )
heres is the data I wont to filter :12206 - CR22
12906 - CR29
13306 - CRAQ
13606 - CRIV
14445 - CEBPL
14706 - CRAV
16006 - CR56
16275 - CENFE
17906 - CRAM
18025 - CEPIC
19406 - CRTP

at the end i should have the row with
12206 12906 et 16006.
Instead I got nothing .
What did I miss ??
PS , I also tried : java.util.regex.Pattern.matches("12206|12906|16006", input_row.etab) and got the same results.

Re: Match Regular expression with tFilterRow

_AnonymousUser — Wed, 24 Oct 2012 08:55:08 GMT

Hello,
this works very well. I have an additional question:
How can I customize the error message from the advanced condition.
I would like the error message to not state "advanced condition failed" but "irregular e-mail adress" for example
thanks for any input!