Output to Comma Delimited File

PowerShell Help
1

Hello,

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?

Thanks,

Frank

2

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.

3

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

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

$groups.Name -join ‘,’
[/pre]

4

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:

5

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!