Wildcard filtering component and regex

Anonymous — Fri, 18 Nov 2016 13:27:29 GMT

I need to filter a MySQL table to 1. exclude a field name in one column and 2. pass rows that contain permutations of keywords that occur within a string in multiple other columns.

Using tMySQLInput --> tMap --> tMySQLInput with !row1.CAT1.equals("IT") in an input expression I have succeeded with goal 1.

[list=*]

I have not been able to find out how to pass a list of wildcards using tFilterRow or any other component. The key words are %temp%, %recruit%, and %sourc%. (I use % because it is familiar to my MySQL queries.)

[list=*]

What I am hoping to find is something like: row1.ColumnName.contains(%temp%|%recruit%|%source%) that I can put in a variable regex expression filter in tMap or an advanced expression in tFilterRow.

I am new to Java coding so any best practices/advice/code would be greatly appreciated. Thank you for the help, I have learned a lot from this community.

Re: Wildcard filtering component and regex

Anonymous — Mon, 21 Nov 2016 07:20:57 GMT

Hi,
Have you checked this component TalendHelpCenter:tMysqlTableList which is used to list the names of a given set of Mysql tables using a select statement based on a Where clause?
Best regards
Sabrina

topic Wildcard filtering component and regex in Talend Studio

Wildcard filtering component and regex

Re: Wildcard filtering component and regex