title: Expression issue for derived column in ssis package
body: <p>I have an string like this format. In my case I need to extract only the characters from string</p>
  
  <p>case</p>
  
  <pre><code>1)12AB
  2)SD12
  3)1WE4
  </code></pre>
  
  <p>output</p>
  
  <pre><code>1)AB
  2)SD
  3)WE
  </code></pre>
  
  <p>I need to extract only the characters. I am using this expression in the derived column in SSIS package</p>
  
  <pre><code>SUBSTRING(MediaIDCode,1,2)
  </code></pre>
  
  <p>but this expression works for only this condition</p>
  
  <pre><code>1)12AB
  </code></pre>
  
  <p>I need to get an expression that works for all the conditions above</p>