Split a field and then populate each element in a new row

[huytonscouser]

I have a report i'm building. One of the fields(WWNS) returned contains a list of "," comma separated variables.


I'd like to split this field, and populate a new row with the same data, but just adding an element each time from the split field.

LUN Service Level LUN Capacity (GB) LUN Used (GB) Disk Rpm WWNS
20BB Silver 34.03 34.03 10000 10000000C9F1D7EF,10000000C9F1D7EE


I want this (WWNS is split and 2nd row created)

LUN Service Level LUN Capacity (GB) LUN Used (GB) Disk Rpm WWNS
20BB Silver 34.03 34.03 10000 10000000C9F1D7EF
20BB Silver 34.03 34.03 10000 10000000C9F1D7EE

Thanks in advance.

 

[kray4660]

If the first part of the string (20BB Silver 34.03 34.03 10000) is always the same length, then I can think of one way using a replace.