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](https://stackoverflow.com/questions/5176815/select-the-values-of-one-property-on-all-objects-of-an-array-in-powershell) — iRon, Oct 18 '19 at 14:25

score 2 · Answer 1 · answered Oct 18 '19 at 10:09

2

You should use:

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

answered Oct 18 '19 at 10:09

Alfredo Liardo

This will work even in older powershell versions - so could be useful for compatibility. – user3012708 Oct 18 '19 at 10:15

score 1 · Accepted Answer · answered Oct 18 '19 at 09:55

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 '19 at 09:55

user3012708

2 Answers2