Powershell Import-csv without headers and where-object

Question

I have a csv file like:

020;1;1;1
030;1;1;1
020;1;2;1
040;1;1;1

Now I want to import-csv the values from the first column and value 020.

I tried:

Import-csv "path/to/file" | Where-Object {$_.[0] -eq "020"

I get a missing Value error.

Can anyone help?

Igor · Accepted Answer · 2017-09-01 12:03:23Z

2

You have three issues there:

The file is not comma separated, but semicolon. Use -Delimiter ';' in Import-Csv.
The file is missing header (column names) information. Use -Header c1,c2,c3,c4 or appropriate column names to specify those.
Filtering should be done by column name, something like c1 -eq '020'

So, your full command should be:

Import-Csv 'path/to/file' -Header c1,c2,c3,c4 -Delimiter ';' | Where-Object c1 -eq '020'

answered Sep 1, 2017 at 12:03

Igor

1,4551 gold badge16 silver badges27 bronze badges

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

2 Comments

Albert Over a year ago

Thank you, that seems to work. One last problem: When I want to query for c1 and c3 how can I do that? code |Where-Object c1 -eq '020 -and c3 -eq '1' @Igor Please help

fdafadf Over a year ago

code |? c1 -eq '020' |? c3 -eq '1' or code |? { $_.c1 -eq '020' -and $_.c3 -eq '1' }

Collectives™ on Stack Overflow

Powershell Import-csv without headers and where-object

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related