The Pipeline: Where-Object, Select-Object, Sort-Object

By the end of this lesson you'll chain commands together with the pipeline, filter the exact objects you want with Where-Object, reshape and trim them with Select-Object, and order them with Sort-Object — then group and measure them. This is the core skill that turns raw cmdlet output into precise, useful answers.

Learn The Pipeline: Where-Object, Select-Object, Sort-Object in our free PowerShell course — an interactive lesson with worked examples, a practice exercise…

Part of the free Powershell course at LearnCodingFast — hands-on lessons with examples you run in your browser, plus practice exercises and a quick quiz.

What You'll Learn

💡 Real-World Analogy

Think of the pipeline as a factory conveyor belt . Whole products (objects) ride along it, not crumbs of text. Where-Object is a quality inspector who pushes off any product that fails a test. Select-Object is a packager who keeps only the parts you want and can stamp on a new label (a calculated property). Sort-Object lines the boxes up in order, and Group-Object stacks identical ones together. Because every item stays a full object the whole way down the belt, each station can still read any of its properties.

1. The Object Pipeline

In older shells, | passes text , so you spend your life slicing strings. PowerShell pipes objects instead — every property and method stays intact from one command to the next. That's why you can filter on $_.WorkingSet or sort on $_.CPU without parsing anything. Inside the cmdlets that take a script block, $_ (or its spelled-out twin $PSItem ) is the current object . Read this worked example, then run it.

2. Filtering with Where-Object

Where-Object keeps only the objects whose condition is $true and drops the rest. You write the test with comparison operators : -eq / -ne (equal / not), -gt / -lt / -ge / -le (numeric), -like (wildcards * ? ), and -match (regex). For a single property test, the short comparison-statement form ( Where-Object Status -eq 'Running' ) is cleaner; for compound logic use the script-block form with -and / -or .

Now you try. Fill in the one blank using the hint in the comment, then run it.

3. Shaping output with Select-Object

Select-Object decides what comes out. Use -Property to keep only the columns you need, -First / -Last to take rows from the top or bottom, and -ExpandProperty to unwrap a single property to its raw value (a clean list of strings instead of wrapper objects). The real power tool is a calculated property : a hashtable @{ Name = '...'; Expression = {...} } that invents a brand-new column on the fly.

Pro Tip

A calculated property's hashtable accepts the short keys n (for Name) and e (for Expression): @{ n='MB'; e={ $_.WorkingSet / 1MB } } . Handy when typing at the prompt — but spell out Name and Expression in saved scripts so a future reader instantly understands them.

4. Ordering with Sort-Object

Sort-Object orders objects by one or more properties, ascending by default. Add -Descending to flip it (the classic "biggest first, then take the top N" pattern), pass several property names to sort by multiple keys, and use -Unique to drop duplicate values after sorting.

Your turn again — two blanks. The "sort descending, then take the first N" combination is one you'll use constantly.

Putting It Together: Group and Measure

Two more cmdlets complete the toolbox. Group-Object buckets items by a shared value and counts each bucket; Measure-Object computes aggregates like Sum, Average, and Maximum; and ForEach-Object runs a script block once per item. Here they all work together on the files in a folder.

Because each file is an object , Group-Object Extension can bucket by the .Extension property and Measure-Object -Property Length can total the .Length — no text parsing anywhere.

Common Errors (and the fix)

• Using = instead of -eq — $_.Status = 'Running' is an assignment, not a test. Comparison uses word operators: -eq , -ne , -gt , -lt .
• Forgetting $_ inside the script block — Where-Object { Status -eq "Running" } fails; write { $_.Status -eq "Running" } , or use the short form Where-Object Status -eq 'Running' .
• Expecting Select-Object Name to give raw strings — it returns objects with a Name property. Use -ExpandProperty Name to get the bare values.
• Sorting numbers as text — if a property is a string, 10 sorts before 2 . Cast it first, e.g. Sort-Object { [int]$_.Size } .
• Putting Select-Object -First 3 before Sort-Object — you'll take the first three of an unsorted list. Sort first, then select.

📋 Quick Reference — Pipeline Cmdlets

Cmdlet

Does

Example

Where-Object

Filter rows

? Status -eq 'Running'

Select-Object

Pick columns / rows

Select -First 5 Name

Sort-Object

Order

Sort CPU -Descending

Group-Object

Bucket & count

Group Extension

Measure-Object

Aggregate stats

Measure -Sum Length

ForEach-Object

Run per item

% { $_.Name }

Frequently Asked Questions

Mini-Challenge: Top 5 memory hogs

No blanks this time — just a brief and an outline to keep you on track. Build it, run it, and check your output against the example in the comments. Filtering and ranking processes is something you'll do constantly in real work.

🎉 Lesson Complete

• ✅ The pipeline passes objects ; $_ / $PSItem is the current item
• ✅ Where-Object filters rows with -eq , -gt , -like , -match and friends
• ✅ Select-Object picks columns, takes -First / -Last , -ExpandProperty , and builds calculated properties
• ✅ Sort-Object orders results; -Descending and -Unique refine them
• ✅ Group-Object , Measure-Object , and ForEach-Object summarise and iterate
• ✅ Next lesson: Error Handling — catch and recover when commands go wrong

Practice quiz

Continue this course

• Previous: Automation and Task Scheduling
• Next: Error Handling: try/catch & ErrorAction