问坚持使用此PS脚本

EN

# Get the content

# $content = Get-Content -Path 'pathtofile.txt'
$content = @('field1,field2,field3', '01/01/2019,b,c') 

# Convert from csv
$csvContent = $content |  ConvertFrom-Csv 

# Add your filter based on the field
$results = $csvContent | Where-Object { $_.field1 -notmatch '01/01/2019'}  | % { $_ }

# Convert your results back to csv if needed
$results | ConvertTo-Csv

# install CsvHelper 
nuget install CsvHelper

# import csvhelper 
import-module CsvHelper.2.16.3.0\lib\net45\CsvHelper.dll

# write the content to the file just for this example
@('field1,field2,field3', '01/01/2019,b,c') | sc -path "c:\temp\text.csv"

$results = @()
# open the file for reading 
try {
$stream = [System.IO.File]::OpenRead("c:\temp\text.csv")
$sr = [System.IO.StreamReader]::new($stream)
$csv = [CsvHelper.CsvReader]::new($sr)

# read in the records
while($csv.Read()){
    # add in the result 
    $result= @{}     

    [string] $value = "";

    for($i = 0; $csv.TryGetField($i, [ref] $value ); $i++) {
        $result.Add($i, $value);
    }
    # add your filter here for the results
    $results.Add($result)
}
# dispose of everything once we are done
}finally {

    $stream.Dispose();
    $sr.Dispose();
    $csv.Dispose();
}