Got the following string and I need to parse it into 9 fields:
I will like to parse this data into 9 fields, since the most the set of ids that this string can have is 9, but not all the time is 9 it can range between 1 to 9 sets of tickets.
I got some logic worked but Im only pulling the first and second set of numbers:
')- 1) AS ID1
I will really appreciate any tip or idea,