PowerShell脚本'IndexOf'方法调用错误的解决方法求助

Why This Happens #

The error pops up because you’re trying to use the IndexOf method on a PSCustomObject—that’s what each entry from your CSV becomes when you run Import-Csv. PSCustomObject doesn’t have an IndexOf method built in, and even if you tried calling IndexOf on the array of objects, it wouldn’t work as expected: PowerShell compares object references by default, so two objects with identical property values are still considered different unless you explicitly match their specific properties.

Solution 1: Use Where-Object to Filter (Recommended) #

The cleanest and most efficient way to exclude servers is to filter your original list using Where-Object, comparing the relevant property (like SourceHostName) against the excluded list. Here’s how:

# Import your CSV files
$serverlist_csv1 = Import-Csv -Path $file1
$exclude_serverlist_csv = Import-Csv -Path $file2

# Extract the list of host names to exclude into an array
$excluded_hosts = $exclude_serverlist_csv.SourceHostName

# Filter the original server list to remove excluded hosts
$filtered_servers = $serverlist_csv1 | Where-Object {
    $excluded_hosts -notcontains $_.SourceHostName
}

This approach avoids loops entirely and leverages PowerShell’s built-in collection handling, making it faster and more readable for most use cases.

Solution 2: Use a Mutable List to Remove Items #

If you need to modify the list in-place (for more complex custom logic), convert your CSV array to a List (which supports removing items) and match objects by their property values:

# Import your CSV files
$serverlist_csv1 = Import-Csv -Path $file1
$exclude_serverlist_csv = Import-Csv -Path $file2

# Convert the server array to a mutable List
$server_list = [System.Collections.Generic.List[PSObject]]$serverlist_csv1

# Loop through excluded servers and remove matches
foreach ($exclude_server in $exclude_serverlist_csv) {
    # Find the server with a matching SourceHostName
    $server_to_remove = $server_list | Where-Object {
        $_.SourceHostName -eq $exclude_server.SourceHostName
    }
    
    # Remove the server if found
    if ($server_to_remove) {
        $server_list.Remove($server_to_remove)
    }
}

# Convert back to an array if needed
$filtered_servers = $server_list.ToArray()

Quick Notes #

• Double-check that the property name (e.g., SourceHostName) matches exactly in both CSV files. If the exclude list uses a different name (like HostName), adjust the comparison to use that instead.
• The Where-Object method is preferred for most scenarios because it aligns with PowerShell’s idioms and is more efficient than manual loops.

内容的提问来源于stack exchange，提问作者user9557011