Parse string of a column and fill another column
Hi, I have a table containing ProductName and I want to generate the OUTPUT column. The OUTPUT column a concatenation of ProductID with Serial#. How do I accurately parse the Serial# and create the OUTPUT column?Serial # examples:07-08_13 means Serial# 07, 08, 1309-12 means Serial# 09, 10, 11, 1201-03_05-08 means Serial# 01, 02, 03, 05, 06, 07, 0801_04_05-08 means Serial# 01, 04, 05, 06, 07, 0809...