Write List data to csv powershell

Question

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

You would need to enumerate and loop over the Permissions properties of the objects. What have you tried? — Santiago Squarzon
– Santiago Squarzon, Commented Apr 20, 2022 at 14:07
We can't tell you, as it depends how you want to handle the Permissions values. Do you want one row per named permission? A semicolon-separated string in a single column? — Mathias R. Jessen
– Mathias R. Jessen, Commented Apr 20, 2022 at 14:07
@MathiasR.Jessen: A single column. as it reflects the Permissions for that specific path — Empty Coder
– Empty Coder, Commented Apr 20, 2022 at 14:11

Mathias R. Jessen · Accepted Answer · 2022-04-20 14:23:44Z

1

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

answered Apr 20, 2022 at 14:23

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Empty Coder Over a year ago

Thanks for the response.

Collectives™ on Stack Overflow

Write List data to csv powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related