过滤CSV回车

Question

试图找出如何过滤特定CSV项目。

CSV内容：

ComputerName,Results 
computerA  ," KB00000 is not installed 
c:\SomeTestFile Version is 2 
c:\SomeTestFile Version is 11.0" 
ComputerB ,%windir%\somefile.exe is Version 1.2 

我需要它在第二列基于所述回车第一过滤并随后筛选不同的参数，如“是version10”或“KB00000丢失”了。

在CSV拟输出：

ComputerName,Results 
computerA ,c:\SomeTestFile Version is 2 
computerA ,c:\SomeTestFile Version is 11.0 
ComputerB ,%windir%\somefile.exe is Version 1.2 

有一个编码块。我可以导入文件，但坚持过滤。

$CSV = Import-Csv File.csv 

Answer 1

与您指定csv

这个脚本：

## Q:\Test\2017\08\24\SO_45870618.ps1 
$FileIn = '.\FileIn.Csv' 
$FileOut = '.\FileOut.Csv' 

$Csv = Import-Csv $FileIn 
$Csv 

$CsvNew = ForEach ($Row in $Csv) { 
    If (!($Row.ComputerName)){ 
     If ($Last) {$Row.ComputerName = $Last} 
    } 
    $Last = $Row.ComputerName 
    ForEach ($line in ($Row.Results -Split('\r?\n'))){ 
     If ($line -NotMatch '^\s*KB\d+\s+is'){ 
      [PSCustomObject]@{ComputerName = $Last.Trim() 
           Results = $line} 
     } 
    } 
} 
"------------" 
$CsvNew 
$CsvNew | Export-Csv $FileOut -NoTypeInformation 

都会有这样的输出：

> Q:\Test\2017\08\24\SO_45870618.ps1 

ComputerName Results 
------------ ------- 
computerA  KB00000 is not installed ... 
ComputerB %windir%\somefile.exe is Version 1.2 
------------ 
computerA c:\SomeTestFile Version is 2 
computerA c:\SomeTestFile Version is 11.0 
ComputerB %windir%\somefile.exe is Version 1.2 

所得FileOut.csv：

> gc .\FileOut.Csv 
"ComputerName","Results" 
"computerA","c:\SomeTestFile Version is 2" 
"computerA","c:\SomeTestFile Version is 11.0" 
"ComputerB","%windir%\somefile.exe is Version 1.2"