parsing - 从CSV删除行

Question

我有一个带有多个标题的csv文档，例如:

"Date","RQ","PM","SME","Activity","Status code""2/2/12","6886","D_WV","John Smith","Recent","2004"

and a text document that is just a list of status codes, one per line.

I am trying to figure out how to remove all lines from the CSV that contain the status codes from the text file.

So far I have tried using:

$m = gc textfile.txt
Select-String data.csv -Pattern $m -NotMatch

但是，这给我留下了额外的数据，例如

data.csv:1"Date","RQ","PM","SME","Activity","Status code"data.csv:2"2/2/12","6886","D_WV","John Smith","Recent","2004"

I have also tried:

gc data.csv | ? { $_ -notlike $m }

那会使用正确的格式，但是不想删除任何值。任何帮助深表感谢。

Answer 1

选择字符串中的那些matchinfo对象可能令人困惑。
这会满足您的需求吗？

$m = gc textfile.txt
select-string data.csv -pattern $m -notmatch |
select -expand line