Write List data to csv powershell

April 20, 2022

I am getting data like below

Path              : C:\Program Files\ibm\gsk8\lib64
ModifiablePath    : C:\Program Files\ibm\gsk8\lib64
IdentityReference : BUILTIN\Administrators
Permissions       : {WriteOwner, Delete, WriteAttributes, Synchronize...}

Path              : C:\Program Files\ibm\gsk8\bin
ModifiablePath    : C:\Program Files\ibm\gsk8\bin
IdentityReference : BUILTIN\Administrators
Permissions       : {WriteOwner, Delete, WriteAttributes, Synchronize...}

I had to use Fomat-List to bring the data this way because without this the last column Permissions was not visible. and when I tried Export-csv for the data, the last column coming as System.Object[]
Please let me know how to write this data to csv

>Solution :

Use Select-Object to create a new calculated property:

... |Select-Object Path,ModifiablePath,IdentityReference,@{Name='Permissions';Expression={$_.Permissions -join ';'}} |Export-Csv -Path path\to\output.csv -NoTypeInformation