Powershell remove row from CSV that contains string

Question

I have a CSV file that I need to remove rows, here is my example

"Name","Local_IP","Remote_IP"
"Sep  1 03:55:57 pc-00017 SymantecServer mserver-4: mmt-5","172.16.48.158","22.22.22.22"
"Sep  1 03:55:57 pc-00017 SymantecServer mserver-4: mmt-5","172.16.48.158","22.22.22.22"
"Sep  1 03:55:57 pc-00017 last message repeated 3 times","","
"Sep  1 03:55:57 pc-00017 SymantecServer mserver-4: mmt-5","172.16.48.158","22.22.22.22"
"Sep  1 03:55:57 pc-00017 last message repeated 2 times","","
"Sep  1 03:55:57 pc-00017 SymantecServer mserver-4: mmt-5","172.16.48.158","22.22.22.22"

I need to remove the row that has the "last message repeated" removed.

I have tried with no luck.

$test = import-csv myfile.csv | where {$_.Name -notcontains "repeated"}
$test | export-csv myfile.csv -notype

Any help plese?

TheMadTechnician · Accepted Answer · 2016-09-06 17:48:19Z

2

Something like this should work I think :

Get-Content C:\Path\myfile.csv | Where{$_ -notmatch "repeated"} | Out-File C:\Path\myNewFile.csv

edited Sep 6, 2016 at 17:48

TheMadTechnician

36.5k3 gold badges48 silver badges63 bronze badges

answered Sep 6, 2016 at 14:50

Sylvain B

5503 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

TheMadTechnician Over a year ago

Almost... If you use Get-Content you then do not have a Name property, so it becomes Where{$_ -notmatch "repeated"}

Eric Over a year ago

The problem I am having now is the Get-Content strips away the CSV format and makes the data unusable.

G42 · Accepted Answer · 2016-09-06 15:13:22Z

-1

-contains is designed to work on arrays, not so good for strings. As per Sylvain's answer Where-Object {$_.Name -notmatch "repeated"} should do what you want.

For more information, check out the Technet page. If nothing else it tell you that match uses regular expressions so as not to trip over this down the line.

answered Sep 6, 2016 at 15:13

G42

10.1k2 gold badges22 silver badges36 bronze badges

Collectives™ on Stack Overflow

Powershell remove row from CSV that contains string

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related