Output to Comma Delimited File


I have the following script to output member of an AD group:

Get-ADGroupMember -identity "Group Name" -Recursive | select Name, objectclass, SamAccountName

The output is displayed as tab delimited. I’d like to make it comma delimited.

Any suggestions?



That’s anyway just the output of the console. If you want to have it in a file you should use Export-Csv. Please read the complete help including the examples to learn how to use it.

You should be able to use -join for this. You’ll want to decide what property you want delimited. I chose Name.

$groups = Get-ADGroupMember -identity “Group Name” -Recursive | select Name, objectclass, SamAccountName

$groups.Name -join ‘,’

It sounds like you’re asking for a CSV file, in which case Olaf’s suggestion is one of the most effective. Also worth noting that if you don’t want to create a file and just want to convert it to CSV in the console there is also a ConvertTo-Csv cmdlet. :slight_smile:

Yep, that was what I was looking for.

Here’s what I have:

Get-ADGroupMember -identity "GroupName" -Recursive | select Name, objectclass, SamAccountName | Export-Csv -Path 'c:\temp\pbi_ad_groupname.csv' -Delimiter "," -NoTypeInformation


Thanks for your help!