I have a column which contains codes and descriptions and need to split them.
Multiple codes may or may not reside in the field.
"CSxxxxx description text here" "WSxxxxx description text here" "CSxxxxx, WSxxxxx, CSxxxxx description text here"
If there are multiple codes, then the description should be repeated, so the output for row 3 above would be 3 lines inserted into a secondary table.
The codes, for the moment, would always be in the format of:
I can write the regex to identify the first couple, but i'm not familiar with cutting this from the string and inserting to another table?