Getting the text between commas

SSIS and Import/Export
1

hey,

i have the following data in a column

Equity,Equity,Materials,Materials,Metals & Mining,Copper,Chile,2500,COMMON STOCK,Mining,Metal-Copper,Basic Materials,4801,United Kingdom,null,null,INCLUDE

i need to get each bit of text between the commas and break them out into single pieces of data so I can popluate certain columns with certain data
like this

Equity
Equity
Materials
Materials
Metals & Mining

etc.

any help would be great

2 
WITH string_cte(string) AS (SELECT 'Equity,Equity,Materials,Materials,Metals & Mining,Copper,Chile,2500,COMMON STOCK,Mining,Metal-Copper,Basic Materials,4801,United Kingdom,null,null,INCLUDE')
SELECT STRING_SPLIT(string,',') FROM string_cte