PowerShell format text file


I get the below output from a PowerShell query. I don’t have access to the server to run the query, so I have no option to influence the output format.


How can I format above content to get something more usable, maybe like a table format like so:


As @alroc notes in a comment on the question, it is possible that objects are available to the OP, given that they state that the output is “from a Powershell query” – if so, simple reformatting of the object array using the usual cmdlets is an option.
By contrast, this answer assumes that only a text representation, as printed in the question, is available.

Dave Sexton’s answer is a simpler and more elegant choice, if:

  • the input has no empty values (the OP’s sample input does).
  • the input file is small enough to be read into memory as a whole.

Consider the approach below to avoid the issues above and/or if you want more control over how the input is converted into custom objects, notably with respect to creating properties with types other than [string]: extend the toObj() function below (as written, all properties are also just strings).


  • Uses ForEach-Object (%) with separate begin, process, and end blocks.
  • The -begin, executed once at the beginning:
    • Defines helper function toObj() that converts a block of contiguous nonempty input lines to a single custom object.
      • toObj() splits an array of lines into an array of contiguous key-value elements, converts that array to a hashtable, which is then converted to a custom object.
    • Initializes array $lines, which will store the lines of a single block of contiguous nonempty input lines
  • The -process block, executed for each input line:
    • If the input line at hand is nonempty: Adds it to the current block of contiguous nonempty input lines stored in array $lines.
    • Otherwise: Submits the current block to toObj() for conversion to a custom object, and then resets the $lines array to start the next block. In effect, toObj() is invoked for each paragraph (run of nonempty lines).
  • The -end block, executed once at the end:
    • Submits the last paragraph to toObj() for conversion to a custom object.
  • Finally, the resulting array of custom objects is passed to Format-Table.


PowerShell format text file by licensed under CC BY-SA | With most appropriate answer!

Leave a Reply