title: Remove Text from a String in SSIS derived column
body: <p>I am trying to remove some unwanted text values from inbound data. The received data looks like: </p>
  
  <pre><code>string;#0 Day(s), 08  Hours,  15  Minutes
  </code></pre>
  
  <p>I applied this in a derived column transformation : </p>
  
  <pre><code>SUBSTRING([Modified By], FINDSTRING([Modified By],"#",1) + 1, FINDSTRING([Modified By],"#", 1))
  </code></pre>
  
  <p>to get only whats after the <code>#</code></p>
  
  <p>The result is: <code>0 Day(s)</code> but you see I'm missing the rest, I'm trying to get everything after <code>#</code> => <code>0 Day(s), 08  Hours,  15  Minutes</code></p>