active directory - powershell: displaying array data next to string data?

Question

When i open the export below in excel, all i can see for MemberOf is System.String[]. How can i show each member with the name, description, userprincipalname next to it?

$Accounts | Get-QADUser | ft name, description, UserPrincipalName, memberOf | Export-Csv C:TempUseraccounts.csv

Answer 1

Try this:

$Accounts | Get-QADUser | select  name, description, UserPrincipalName, @{ n="memberof"; e={ $_.memberof }}  | Export-Csv -NoTypeInformation .file.csv

Some info for 'calculated property' here

Some info for 'why-can-t-i-pipe-format-table-to-export-csv-and-get-something-useful'