title: Filtering table column using multiple wildcards
body: <p>This question relates to Talend Open Studio but really lies within the Regex Java code realm.</p>
  
  <p>I need to filter a MySQL table to </p>
  
  <ol>
  <li>exclude a field name in one column and </li>
  <li>pass  rows that contain permutations of keywords that occur within a string in multiple other columns.</li>
  </ol>
  
  <p>Using tMySQLInput --> tMap --> tMySQLInput with !row1.CAT1.equals("IT") as an input expression I have succeeded with goal 1.</p>
  
  <p>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.) </p>
  
  <p>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.</p>
  
  <p>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.</p>