Ralluhb Ralluhb - 1 year ago 88
PowerShell Question

How to output to two columns in Powershell with XML

I have a simple menu to run some tasks, the menu reads variables through an xml config.

At the moment it outputs to screen like this:

  1. App One.

  2. App Two.

  3. App Three.

  4. App Four.

However I would like to output it like this (due to menu getting larger):

  1. App One. 3. App Three.

  2. App Two. 4. App Four.

Can you look at this code and advise how I can implement the above?

<?xml version="1.0"?>
<Description>App One</Description>
<Description>App Two</Description>
<Description>App Three</Description>
<Description>App Four</Description>

foreach ($Item in @($Config.Menu.Actions.Id))
Write-Host ("{0}.`t{1}." -f $Item.Option,$Item.Description)}

Would I need to use maybe split/regex?

Answer Source

The following code will add a newline character (`n) to the menu string if the item count is even. Meaning you will have two items on each line of your menu.

$c = 1 
$menu = ""

foreach ($Item in @($Config.Menu.Actions.Id)) {

    $menu += ("{0,2}.`t{1,10}." -f $Item.Option,$Item.Description)
    If($c % 2 -eq 0){$menu +="`n"}


Write-Host $menu

Using -f you can format your columns to a set size, the following formats $Item.Option to have a 2 width and $Item.Description to have a width of 10 characters.

"{0,2}.`t{1,10}." -f $Item.Option,$Item.Description
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download