Select-CSV Cmdlet
Searches CSV data.
Syntax
Select-CSV [parameters]
Remarks
The Select-CSV cmdlet allows you to use a syntax similar to SQL SELECT statements to search CSV data.
$conn = Connect-CSV -Location 'C:\MyCSV' -URI 'token' Select-CSV -Connection $conn -Table "NorthwindOData" -Columns @("Email","Username") -Where "Email='[email protected]'"