'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
Solution 1:[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
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mathias R. Jessen |
