I have a table with Last_Name, Address,Zip etc.
Last_name has names like 'Tinker-Sackett' and 'Schiff-Seehafer'
I would like to find a way to split those names into the two parts and return duplicate rows of all other fields. So for example if I had a dataset with one row:
last_name = 'Tinker-Sackett'
zip = '99999'
I would want three records coming out of data-flow:
1 with 'Tinker-Sackett' as last_name and zip = '99999'
1 with 'Tinker' as last_name and zip = '99999'
1 with 'Sackett' as last_name and zip = '99999'
So you can see- i need it split by a '-' and the '-' removed.
Is there a way to do this in a scripting object or even SQL?