Powershell turn strings into array with headings

Question

I'd like to create a table with headings from a series of strings, which have been pulled from an output. I've already used this...

$Scopearray = @("$server","$ip","$ScopeName","$Comment")

To turn this...

$ip = $Trimmed[0]
$server = $Trimmed[1]
$ScopeName = $Trimmed[2]
$Comment = $Trimmed[3]

Into this:

PS C:\WINDOWS\system32> $Scopearray 
MyServer.domain
10.1.1.1
NameofScope
ScopeDetails

But I need to turn that into a table, something like this:

Table Example

I've tried the below, and a copule of other multidimentional examples, but I'm clearly missing something fundamental.

$table = @()
foreach ($instance in $Scopearray) {
$row = "" | Select ServerName,IP,ScopeName,Comment
$row.Heading1 = "Server Name"
$row.Heading2 = "IP Address"
$row.Heading3 = "Scope Name"
$row.Heading4 = "Comment"
$table += $row
}

Why dont you create an object inside the foreach loop and add the object to an arraylist. Declare the arraylist outside the loop. And inside the loop you can still do your trimming operation and assign that value to that object. Makes sense? — Ranadip Dutta
– Ranadip Dutta, Commented Aug 24, 2017 at 2:54

Ansgar Wiechers · Accepted Answer · 2017-08-24 10:27:44Z

2

Create objects from your input data:

... | ForEach-Object {
    New-Object -Type PSObject -Property @{
        'Server Name' = $Trimmed[1]
        'IP Address'  = $Trimmed[0]
        'Scope Name'  = $Trimmed[2]
        'Comment'     = $Trimmed[3]
    }
}

In PowerShell v3 and newer you can simplify that by using the [PSCustomObject] type accelerator:

... | ForEach-Object {
    [PSCustomObject]@{
        'Server Name' = $Trimmed[1]
        'IP Address'  = $Trimmed[0]
        'Scope Name'  = $Trimmed[2]
        'Comment'     = $Trimmed[3]
    }
}

PowerShell displays objects with up to 4 properties in tabular form by default (unless the objects have specific formatting instructions), but you can force tabular output via the Format-Table cmdlet if required:

... | Format-Table

Note that you need Out-String in addition to Format-Table if for instance you want to write that tabular representation to a file:

... | Format-Table | Out-String | Set-Content 'C:\output.txt'

answered Aug 24, 2017 at 10:27

Ansgar Wiechers

202k27 gold badges286 silver badges363 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ScriptMonkey Over a year ago

For completeness, this outputs four identical values, so adding ` | select -First 1` at the end provides the exact answer, but otherwise a great solution.

Collectives™ on Stack Overflow

Powershell turn strings into array with headings

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related