I need to split out list data in a column in order to made the data more readable.
For example:
select * from mytable;
ID TEXT
-- -----------
1 RED,GREEN,BLUE,YELLOW,ORANGE,VIOLET
2 GREEN,ORCHID,SLATEBLUE,RED,YELLOW
What I would like to see instead:
ID TEXT
-- -----------
1 RED
GREEN
BLUE
YELLOW
ORANGE
VIOLET
2 GREEN
ORCHID
SLATE
RED
YELLOW
The number if items in the TEXT column ranges from a minimum of four items..it also may have have over 20!
The elements are all separated by a comma (no space).
Finally, the for now, the data does not need to be sorted, but would be nice in the future!
Thanks, I really appreciate any insight you all might be able to provide!!!
KSL.