I am using the derived column transformation for my package and i have a column that has the name of a city, state and company name.. 'New York, NY-The First Bank'. My goal is to grab only the company name, and put it in another column. I am using the LTRIM Expression
LTRIM(SUBSTRING([Customer Name],FINDSTRING([Customer Name],"-",1),LEN([Customer Name])))
This is grabbing the company name along with the '-'. Any suggestions on how i can get rid of the '-', I have tried to use 2 LTRIM's but it gives me the same result.
Thank you.. :)