Hello, I am hoping for some help with parsing a string in a data set to create a one-many relationship. What I have: A data set with two variables/fields. 1 containing an Order_Number, the other containing Order_notes / user input free flow text Order_Number Order_Notes 12345 14-07-05[userid1] Note1 14-07-05[userid2] Note2 14-07-05[userid3] Note3 What I need: A similiar data set, but with the User_Notes parsed into individual records: Order_Number Order_Notes 12345 14-07-05[userid1] Note1 12345 14-07-05[userid2] Note2 12345 14-07-05[userid3] Note3 Obviously, my dataset is much larger, and the number of Order_Notes for each Order_Number is dynamic. Also, the length of the UserID is variable. However, each user note is seperated by a carriage return inside the Order_Notes. Any help is very greatly appreciated. Thank you, Cory
... View more