Is there a way to break a delimited variable into columns of a temp table similar to the procedure for importing a delimited file? For example I want to break the following string:
PONum:123456, Item:test1, Quantity:3
Into a temp table to look like this:
PONum:123456 | Item:test1 | Quantity:3
PONum:123456, Item:test1, Quantity:3
Into a temp table to look like this:
PONum:123456 | Item:test1 | Quantity:3