How to use a Where-Object on a Csv and get the output without header

Question

I have a csv file which looks like below

Name
Jonh
Jimmy
Sunny
Dany

So to get compare the list of names in CSV file with another name i used the below command

$csv = $csv | where {$_.Name -ceq "Jimmy"}

I am getting output as below

Name
------
Jimmy

can I have just just have the output as

Jimmy

Instead of

Name
-------
Jimmy

EDIT: Formatting

Possible duplicate of Select the values of one property on all objects of an array in PowerShell — iRon
– iRon, Commented Oct 18, 2019 at 14:25

Alfredo Liardo · Accepted Answer · 2019-10-18 10:09:07Z

2

You should use:

$csv = $csv | where {$_.Name -ceq "Jimmy"} | Select-Object -ExpandProperty Name

answered Oct 18, 2019 at 10:09

Alfredo Liardo

1152 gold badges2 silver badges10 bronze badges

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

1 Comment

This will work even in older powershell versions - so could be useful for compatibility.

user3012708 · Accepted Answer · 2019-10-18 09:55:10Z

1

I believe in later versions of powershell you can simply call a property name from the results, like so:

$csv = ($csv | where {$_.Name -ceq "Jimmy"}).Name

answered Oct 18, 2019 at 9:55

user3012708

9682 gold badges14 silver badges45 bronze badges