How to split a comma-seperated values into multiple columns?

Asked Apr 02 '18 at 08:12

Active Apr 02 '18 at 18:23

Viewed 28 times

Data :
Teams
------------
India, Tamil Nadu, Chennai Super kings

Here Teams is a Column Name.

I want this output given below,

Team 1 |     Team 2    | Team 3
-------------------------------------------------------------
India      | Tamil Nadu | Chennai Super kings

Thanks in advance

edited Apr 02 '18 at 18:23

S3S

asked Apr 02 '18 at 08:12

Giri Bkm

Will it always be three? – S3S Apr 02 '18 at 18:24
Possible duplicate of [How to split a comma-separated value to columns](https://stackoverflow.com/questions/10581772/how-to-split-a-comma-separated-value-to-columns) – nathan_jr May 06 '18 at 16:47

0 Answers0