This topic contains 3 replies, has 2 voices, and was last updated by
June 18, 2016 at 11:06 am #43828ParticipantTopics: 1Replies: 1Points: 0Rank: Member
I am trying to convert some output into nice CSV files for later reference.
E.g I am running in Office 365 Get-TransportConfig and it returns a list of properties and values. e.g.
AddressBookPolicyRoutingEnabled : False
AnonymousSenderToRecipientRatePerHour : 1800
I would like to export all of these values into a CSV with the column headings:
Any help would be greatly appreciated.
June 18, 2016 at 11:19 am #43832ParticipantTopics: 37Replies: 143Points: 0Rank: Member
you can use the 'Export-CSV' cmdlet. Simply pipe your 'Get-TransportConfig' cmdlet to 'export-csv', set the path and job done 🙂
June 18, 2016 at 2:09 pm #43845ParticipantTopics: 1Replies: 1Points: 0Rank: Member
Sorry this does not work, since all the values are returned in one row, and each property is a separate column.
I am wanting to substitute the property/value pairs into a custom table, with each on a separate row.
I guess I could reformat the data once it is already in CSV, but out of interest I would like to know how I might be able to manipulate the output in powershell.
June 19, 2016 at 10:01 am #43883ParticipantTopics: 37Replies: 143Points: 0Rank: Member
you can use the Export-Csv -Delimiter "," which should separate your output. If that does not help, pop your code up and i can see how the data is being outputted.
The topic ‘Format List Properties into Excel’ is closed to new replies.