title: SSIS How to get part of a string by separator using Derived Column
body: <p>I trying to write an SSIS expression to get the right part of a string before the separator and then put the new string in a new column. I have used Substring and Findstring in derived column but I am having trouble.</p>
  
  <pre><code>Company
  Virgin Altantic - F30008 
  Google - F38115
  </code></pre>
  
  <p>I need to retrieve F30008 and F38115.</p>
  
  <p>I used the expression:</p>
  
  <p><code>(DT_STR,65,1252)(FINDSTRING(Company,"- ",1) != 0 ? (SUBSTRING(Company,1,FINDSTRING(Company,"-",1) + 2)) : Company)</code></p>
  
  <p>From this expression I got:</p>
  
  <pre><code>Company
  Virgin Altantic - 
  Google - 
  </code></pre>