Splitting a column into multiple columns from a CSV file in powershell

I am new to using powershell and I am in need of some assistance.

I have a csv file that looks like this:

DisplayName,AllJSSUSers,ALLMobileDevices,LimitToUsers,Exclusions,DepartmentEx,IconURL,ID Aurasma,TRUE,TRUE, “G_Year 4,G_Year 7,G_Year 11,G_Year 6,G_Year 10,G_Year 5,G_Year 9,G_Teaching Staff,G_Year 8,G_Supply Teachers,G_Year 3,G_Year 12”,,,,5

What I would like to do is split the column “LimitToUsers” where the commas are into multiple column and then output that to a new csv file.

I have tried researching this and so far have got no where. Can anyone show me how to do this?

Thank you


submitted by /u/Wycombegav
[link] [comments]

Leave a Reply