asked
split data delimited by character
Hello I really would appreciate someone`s help I`m a newbee in all of this SQL-SSIS stuff I have the following table in SQL: ![alt text][1] And I need to create a table with columns that contain the AreaPath column and parsed by the delimiter “\” Meaning my final goal is this: ![alt text][2] Couple of important things: 1. The original table is constantly changing (every 10 minutes) 2. I have SQL 2014 3. I can use SSIS to do so (I prefer to, then SQL) [1]: /storage/temp/4451-original-table.png [2]: /storage/temp/4452-desired-table.png
Hi, Try using the FINDSTRING function in SSIS (found in the Derived Column transformation) see [here][1] and [here][2] [1]:
https://docs.microsoft.com/en-us/sql/integration-services/expressions/findstring-ssis-expression [2]:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1516f1d5-ec4b-4ee4-8adf-2cde9652ca2a/how-to-get-charindex-of-second-position-of-?forum=sqlintegrationservices
Thanks!I have managed to do it using the TOKEN function in SSIS!
18 People are following this question.
