Output to Comma Delimited File

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

Viewing 3 reply threads
  • Author
    Posts
    • #156707
      Participant
      Topics: 12
      Replies: 17
      Points: 152
      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: 1640
      Points: 3,110
      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: 12
        Replies: 17
        Points: 152
        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: 408
      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: 511
      Points: 1,306
      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. 🙂

Viewing 3 reply threads
  • The topic ‘Output to Comma Delimited File’ is closed to new replies.