问Powershell使用where-object

EN

select * | where {($_ | ConvertTo-Csv -NoTypeInformation)[1] -like '*"Alabama"*'}

# Import CSV file and feed it to the pipeline
Import-Csv -Path .\My.csv |
    # For each object
    ForEach-Object {
        # Psobject.Properties returns all object properties
        # (Psobject.Properties).Value returns only properties' values
        # -contains operator checks if array of values contains exact string 'Alabama'
        # You can also use -like operator with wildcards, i.e. -like '*labama'
        if(($_.PSObject.Properties).Value -contains 'Alabama')
        {
            # If any of the object properties contain word 'Alabama',
            # write it to the pipeline, else do nothing.
            $_
        }
    }