This is a REALLY common question, and if you have any experience with VBScript, or Perl, or some similar scripting language, you’ll go down completely the wrong path. The thing to remember is that PowerShell already knows how to format tables<\/i>! You just have to give it your data in a way it understands, so it can make a table out of it. So what does PowerShell’s Format-Table cmdlet know how to work with?<\/p>\n
Objects.<\/p>\n
So the trick is to format whatever data you’re working with as an object. In other words, let’s say you have four variables that contain your data: $data1, $data2, $data3, and $data4. You might be tempted to create a table by doing this:<\/p>\n
Write-Host $data1 $data2 $data3 $data4<\/p>\n
And so forth. You might start your script with a statement that writes out column headers, even. But that’s not the "PowerShell way" of doing things. Here’s what is:<\/p>\n
This gives you an object, stored in $out, containing four properties: ColumnA, ColumnB, ColumnC, and ColumnD. Simply output that by using Write-Output $out<\/b> and you’re done: PowerShell will happily format it as a table. Since it only has four properties, you don’t even have to use the Format-Table cmdlet – PowerShell will choose a table layout automatically.<\/p>\n A bonus of this technique is that you can also use other cmdlets, like Export-CSV, ConvertTo-HTML, and more. By having your output data contained within an object, all of PowerShell’s various exporting and formatting options become possible, with no extra work on your part.<\/p>\n Think of an "object" as a row in a table; each property of the object becomes a column of the table. Here’s an example function that accepts a computer name, makes up some data as output, and outputs the object. I’m reading in a bunch of computer names from a file, and sending each one to the function. The result is a single output table.<\/p>\n I could actually have written the function to accept pipeline input directly, making this possible:<\/p>\n But I didn’t, simply because the way I used is a bit easier to follow as a learning example. So, the moral: Don’t output text. Output objects.<\/p>\n Thanks to Jon<\/b> for sending this one in.<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" This is a REALLY common question, and if you have any experience with VBScript, or Perl, or some similar scripting language, you’ll go down completely the wrong path. The thing to remember is that PowerShell already knows how to format tables! You just have to give it your data in a way it understands, so […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[27,25],"tags":[86,85,82,83,28,84],"class_list":["post-379","post","type-post","status-publish","format-standard","hentry","category-ask-the-experts","category-windows-powershell","tag-format","tag-formatting","tag-objects","tag-output","tag-powershell","tag-table"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=379"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/379\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}$out = new-object psobject
\n$out | add-member noteproperty ColumnA $data1
\n$out | add-member noteproperty ColumnB $data2
\n$out | add-member noteproperty ColumnC $data3
\n$out | add-member noteproperty ColumnD $data4<\/code><\/p>\nfunction MakeData($name) {
\n $data1 = $name.ToLower()
\n $data2 = $name.ToUpper()
\n $data3 = $name
\n $out = new-object psobject
\n $out | add-member noteproperty LowerCase $data1
\n $out | add-member noteproperty UpperCase $data2
\n $out | add-member noteproperty Original $data3
\n write-output $out
\n}
\n$computers = get-content c:\\names.txt
\nforeach ($computer in $computers) {
\n makedata $computer
\n}<\/code><\/p>\ngc c:\\names.txt | makedata<\/code><\/p>\n