title: Getting the string in between characters using SSIS
body: <p>I read up on Left, Right, Substring, CharIndex, but wasn't able to implement the solution correctly. I want to convert:</p>
  
  <p>1;#Jackson, Michael  (X) 
  To: 
  Jackson, Michael</p>
  
  <p>Basically, I want to remove 1;# from the left and spaces and (X) after the name ends. I cannot use any hardcoded numbers, since the length of first and last name could vary. Can you please assist? I want to do this using the Derived Column component in SSIS.</p>