How to create PowerShell datastructure that works well with format-table

Question

When I do "$states2 | ft" I get this:

Name                           Value
----                           -----
NY                             State
AZ                             State

When I would rather get this:

Name    Acres   Population   Founded  FullName
----    -----   ----------   -------  --------
NY        50           100      1645  New York
AK       100           512      1745  Alaska

What am I doing wrong?

Here is my data structure in the form of a class:

class State {
    [Int64]$Acres
    [Int64]$Population
    [Int16]$Founded
    [string]$FullName
    }

$States2 = @{}
$States2.AK = [State] @{Population = 512; Founded = 1745; Acres = 100; FullName = "Alaska"}

$States2.NY = [State]::new()
$States2.NY.Acres       = 50
$States2.NY.Population = 100
$States2.NY.Founded    = 1652
$States2.NY.FullName   = "New York"

Thanks in advance

This isn't the complete answer, but it's fairly similar: stackoverflow.com/questions/20874464/… — mjsqu
– mjsqu, Commented Oct 8, 2018 at 4:20

Mathias R. Jessen · Accepted Answer · 2018-10-08 04:34:21Z

2

You'll need to make the abbreviated name part of the class definition:

class State {
    [string]Name
    [Int64]$Acres
    [Int64]$Population
    [Int16]$Founded
    [string]$FullName
}

$States2 = @{}
$States2.AK = [State] @{Name = "AK"; Population = 512; Founded = 1745; Acres = 100; FullName = "Alaska"}

$States2.NY = [State]::new()
$States2.NY.Name       = "NY" 
$States2.NY.Acres      = 50
$States2.NY.Population = 100
$States2.NY.Founded    = 1652
$States2.NY.FullName   = "New York"

If you only want the show the values in the $States2 hashtable, do:

$States2.Values |Format-Table

answered Oct 8, 2018 at 4:34

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

2 Comments

chris Over a year ago

Thank you very much Mathias!

Mathias R. Jessen Over a year ago

@chris You're welcome! If my answer solved your problem, please consider marking it "accepted" by clicking the checkmark on the left

Collectives™ on Stack Overflow

How to create PowerShell datastructure that works well with format-table

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related