PowerShell reading sorting data

Question

I have a question: I want to store data in a variable with three columns and then process it. So I looked at an example with hash tables, which seemed great but then I need three columns, and I want to be able to run queries against this with it having say 100 rows.

What's the best way of doing this?

Example

Keith Hill · Accepted Answer · 2014-02-05 20:03:09Z

3

You can create custom objects, each with three properties. That will give you the three column output. If you have V3 you can create custom objects using a hashtable like so:

$obj = [pscustomobject]@{Name='John';Age=42;Hobby='Music'}
PS> $obj | ft -auto

Name Age Hobby
---- --- -----
John  42 Music

If you are on V2 you can create these objects with New-Object:

$obj = new-object psobject -Property @{Name='John';Age=42;Hobby='Music'}

edited Feb 5, 2014 at 20:03

answered Feb 5, 2014 at 19:23

Keith Hill

204k44 gold badges370 silver badges377 bronze badges

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

2 Comments

Hunter Eidson Over a year ago

If you have v2 or v1, you can still create an object to do it, it just requires a little more work. You'll need to look at New-PSObject and Add-Member to replace that first line.

Keith Hill Over a year ago

@HunterEidson Sure. But are folks really still hanging onto V2? Folks, move to v3 at the very least. ;-) That said, I updated my answer to show how to do this in V2.

mjolinor · Accepted Answer · 2014-02-05 19:23:32Z

2

I would create an array or collection of custom PS Objects, each having 3 properties, then use the Powershell comparison operators on that array/collection to do my queries.

see:

Get-Help about_object_creation
Get-Help about_comparison_operators
Get-Help Where-Object

answered Feb 5, 2014 at 19:23

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Collectives™ on Stack Overflow

PowerShell reading sorting data

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related