CODEWITHSUNDEEP
powershell
Empty Coder
Empty Coder

Reputation: 589

Write List data to csv powershell

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

Upvotes: 0

Views: 48

Answers (1)

Mathias R. Jessen
Mathias R. Jessen

Reputation: 174485

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

Upvotes: 1

Related Questions