Powershell Modify Select-Object Property Before Output

Question

How would I go about removing the leading "{Storage consumed:, " and the trailing "}" from the DiskAllocation property of this Select-Object so that only the size remains?

For Example: {Storage consumed:, 48.62 MB} becomes 48.62 MB

I know that I need to do some sort of replace statement with regex, but I am a beginner with Powershell. Any help would be appreciated.

$DS | Select-Object -Property Computer, Name, ObjectType, DiskAllocation | Format-Table -AutoSize | Out-String | Write-Host -ForegroundColor Cyan

The output currently looks like this:

The OP probably realized by now, but to anyone coming here from google, this is a classic example of what a lot (including me) of people go through when going to Powershell after a life using members of the Bourne Shell family. The person needs to go through a change in mindset to stop seeing things as text needing to be processed and starting to see things as objects with properties everywhere. — Doodad
– Doodad, Commented Mar 17, 2021 at 19:14

Mathias R. Jessen · Accepted Answer · 2020-04-24 12:47:51Z

1

Judging from the output, the DiskAllocation property holds a two-item array - you can select only the second item with a calculated property:

Select-Object -Property Computer, Name, ObjectType, DiskAllocation, @{Name='DiskAllocation';Expression={$_.DiskAllocation[1]}}

answered Apr 24, 2020 at 12:47

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

1 Comment

TechFA Over a year ago

You're right, that calculated property is exactly what I needed. I did need to remove the first "DiskAllocation," you had in your answer. I was getting Select-Object : The property cannot be processed because the property "DiskAllocation" already exists. Once I took that out, it worked like a charm. Thanks for the help!

Collectives™ on Stack Overflow

Powershell Modify Select-Object Property Before Output

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