Import-CSV Where-Object as an Array

Question

I have the following code working - based on the great help here on stackoverflow - to parse a CSV file. I would like to replace the $_.File - matches with data from a second CSV file that contains a list of files.

Import-csv "D:\NTFSInfo_C_.csv" -header("File","ParentName","Extension","Attributes","SizeInBytes","CreationDate","LastModificationDate","LastAccessDate","LastAttrChangeDate","Status","USN","FRN","ParentFRN","FileNameCreationDate","FileNameLastModificationDate","FileNameLastAccessDate","FileNameLastAttrModificationDate")|
  Where-Object{($_.File -match "null.sys") -or ($_.File -match "explorer.exe")} |
  Select-Object File, CreationDate, FileNameCreationDate, ParentName |
  Export-CSV -Path c:\NTFS_KNOW_IOC.csv -NoTypeInformation

Question. How do I read a list of file names from a TXT or CSV into an array and then use that array in the Where-Object as shown above?

Thank you!

Shay Levy · Accepted Answer · 2012-06-19 08:00:04Z

2

$files = Get-Content files.txt
...

Where-Object{($files -match "null.sys") -or ($files -match "explorer.exe")} ...

edited Jun 19, 2012 at 8:00

answered Jun 18, 2012 at 21:06

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

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

3 Comments

user1373685 Over a year ago

Thanks Shay. When I test the code... The files from my files.txt file loads. Thanks. It seems that the where-object doesnt loop through the files list. Do I need do add a loop to get this going?

Shay Levy Over a year ago

No, the code doesn't loop through the file list, it just checks if there's a match.

user1373685 Over a year ago

cool. If I wanted to check what was in files.txt against the data in NTFSInfo_C_.csv I would just add a loop? Or is there some sneaky cool way to do it in PS? thanks for you time.

Collectives™ on Stack Overflow

Import-CSV Where-Object as an Array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related