<div>
LTRIM(RTRIM(SUBSTRING([Cus<wbr />tomer Name],CHARINDEX('-', [Customer Name]) <b>- 1</b>,8000)))
</div>


LTRIM(RTRIM(SUBSTRING([Customer Name],CHARINDEX('-', [Customer Name]) - 1,8000)))

<div>
Getting error message, it does not recognize the CHARINDEX..
</div>


Getting error message, it does not recognize the CHARINDEX..

<div>
Then you must not be using SQL Server.<br />
<br />
I guess go back to FINDSTRING, as in your original post, just add the &quot;- 1&quot; after the SUBSTRING:<br />
<br />
LTRIM(SUBSTRING([Customer Name],FINDSTRING([Customer<wbr /> Name],&quot;-&quot;,1) <b>- 1</b>,LEN([Customer Name])))
</div>


Then you must not be using SQL Server.

I guess go back to FINDSTRING, as in your original post, just add the "- 1" after the SUBSTRING:

LTRIM(SUBSTRING([Customer Name],FINDSTRING([Customer Name],"-",1) - 1,LEN([Customer Name])))

<div>
FINDSTRING (SSIS Expression)<br />
<br />
<a href="https://msdn.microsoft.com/en-us/library/ms141748.aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/ms141748.aspx</a>
</div>


FINDSTRING (SSIS Expression)

https://msdn.microsoft.com/en-us/library/ms141748.aspx [https://msdn.microsoft.com/en-us/library/ms141748.aspx]

<div>
+1 did the trick.. Thank you. :)
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
<br />
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 <br />
<br />
LTRIM(SUBSTRING([Customer Name],FINDSTRING([Customer<wbr /> Name],&quot;-&quot;,1),LEN([Customer<wbr /> Name])))<br />
<br />
This is grabbing the company name along with the '-'. &nbsp;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. <br />
<br />
<br />
Thank you.. :)
</div>
</div>


Hi Experts, 

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.. :)

LTRIM(LTRIM.....

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.