Output to Comma Delimited File

Welcome Forums General PowerShell Q&A Output to Comma Delimited File

This topic contains 4 replies, has 4 voices, and was last updated by

 
Participant
4 months ago.

  • Author
    Posts
  • #156707

    Participant
    Topics: 9
    Replies: 14
    Points: 108
    Rank: Participant

    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

  • #156711

    Participant
    Topics: 1
    Replies: 1528
    Points: 2,581
    Helping Hand
    Rank: Community Hero

    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.

    • #156878

      Participant
      Topics: 9
      Replies: 14
      Points: 108
      Rank: Participant

      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!

  • #156723

    Participant
    Topics: 0
    Replies: 36
    Points: 404
    Helping Hand
    Rank: Contributor

    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 ','
    
  • #156741

    Participant
    Topics: 2
    Replies: 483
    Points: 1,150
    Helping Hand
    Rank: Community Hero

    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. 🙂

The topic ‘Output to Comma Delimited File’ is closed to new replies.