October 30, 2018 at 12:15 am
Comments posted to this topic are about the item SSIS Basics: Data cleansing using derived columns
MCSE, MCSA SQL Server Database Developer/Administrator
October 30, 2018 at 1:30 pm
SSIS has a function named TOKEN that is much easier to utilize than SUBSTRING and FINDSTRING. It can also be utilized to break up the string based on multiple delimiters if needed.
Jeffrey Williams“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers fasterManaging Transaction Logs
October 30, 2018 at 2:12 pm
Jeffrey Williams 3188 - Tuesday, October 30, 2018 1:30 PMSSIS has a function named TOKEN that is much easier to utilize than SUBSTRING and FINDSTRING. It can also be utilized to break up the string based on multiple delimiters if needed.https://docs.microsoft.com/en-us/sql/integration-services/expressions/token-ssis-expression?view=sql-server-2017
thanks for your feedback Jeffrey, to be honest i did not know that function, I will give it a try...
March 5, 2019 at 10:00 am
It looks like your formula for the LastName causes the first character to be a blank. You need to start the substring one place further.SUBSTRING(Name,FINDSTRING(Name," ",1) + 1,LEN(Name))
SUBSTRING(Name,FINDSTRING(Name," ",1) + 1,LEN(Name))
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply