title: exclude data having specific value [substring within a string] using pentaho
body: <p>I have a column "Number field" (Excel sheet).   It has value as shown below.</p>
  
  <pre><code>Test_Number Number_field
  1            0011 10 00A34 PS
  2            0011 10 00A34 PS
  3            0010 01 00A30 PS
  4            0010 01 00A30 PS
  5            0010 01 00A35 PS
  6            0010 01 00A35 PS
  </code></pre>
  
  <p>Now, from these i need to remove those which contains <code>"0A34"</code> and <code>"0A35"</code>. How can i achieve this? I tried "filter" option, but I cannot search substring in a string using this. Please help</p>