Home Forums SQL Server 2005 SQL Server 2005 Integration Services Split string RE: Split string

  • February 4, 2015 at 6:12 am

    #1775275

    abhas (2/4/2015)

    Thanks Phil for your suggestion. I am able to split lastName as Pawar by using below code of stuff.

    SUBSTRING(Name,1,FINDSTRING(Name,",",1) - 1)

    but not able to identify FirstName as Ramesh. M trying on that

    Thanks

    Abhas.

    Good stuff. To get Ramesh, you need to do something like this:

    1) Find the position of the comma.

    2) Find the position of the space, starting searching from the position of the (comma + 1).

    3) Extract the string between (1) + 1 and (2)