title: Update field with partial match
body: <p>i have a parsing calculation in a field called "output" that looks at another field (called "parser") and updates "output" with a portion of the data from "parser" (specifically, The data is "XCX0001-user", the calculation looks for "-user" and then updates the output field with "XCX001").  </p>
  
  <p>Here is what I have so far:</p>
  
  <pre><code>If ( FilterValues ( layout::parser ; "-user" )  ; 
  Left ( layout::parser ; Position ( layout::parser ; "-" ; 1 ; 1 ) -1 ) 
  ; 0 )
  </code></pre>
  
  <p>So if the field doesnt have the "-user" portion, it will print a '0', not "XCX001". Though it doesnt look like "Filter Values" looks for partial matches. Any way to fix this?</p>
  
  <p>Thanks.</p>