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?