arrays - 在Powershell中根据CSV过滤搜索结果

Question

我对一些想法感兴趣，这些想法将涉及如何对文件系统的搜索进行编码以找到与主CSV文件中包含的任何条目匹配的文件。我具有搜索文件系统的功能，但是事实证明，对CSV进行过滤比我想象的要难。我有一个带有名称和IPaddr header 的csv:

#create CSV object
$csv = import-csv filename.csv

#create filter object containing only Name column
$filter = $csv | select-object Name

#Now run the search function 
SearchSubfolders | where {$_.name -match $filter} #returns no results

我猜我的问题是这样的:我可以针对这样的管道中的数组进行过滤吗？？？

Answer 1

您需要一对循环:

#create CSV object
$csv = import-csv filename.csv

#Now run the search function
#loop through the folders
foreach ($folder in (SearchSubfolders)) {
    #check that folder against each item in the csv filter list
    #this sets up the loop
    foreach ($Filter in $csv.Name) {
        #and this does the checking and outputs anything that is matched
        If ($folder.name -match $Filter) { "$filter" }
    }
}