title: Pentaho data Integration - cut a string after comma (not in a fixed position)
body: <p>In Pentaho data-integration I need (from a Excel Input) to replace a specific string. </p>
  
  <p>I need to delete all characters after the first comma (it can be in a casual position), like this:</p>
  
  <p><code>"A,b,c,f" -&gt; "A"</code></p>
  
  <p><code>"aaaaa,bbbb,cccc" -&gt; "aaaaa"</code></p>
  
  <p>I've tried <code>string cut</code> but it allows meto cut after a specific number of characters (not a specific word or character, such as comma).</p>
  
  <p>In my sql is : <code>SUBSTRING_INDEX(technician, ',', 1)</code>.. but what would it be with Pentaho?</p>
  
  <p>Thanks </p>