Powershell - Delete all lines that contain a string from a seperated file

Question

question

StoreAdvs-5792 asked Mar 7, '21 RichMatheisen-8856 commented Mar 7, '21

Powershell - Delete all lines that contain a string from a seperated file

Hi,

i need to remove swear words from a .txt file based on strings on a keyword.txt file.
Example:

Input.txt contains:
We go too the zoo.
Whats the weather today noob?
Let me be stupid.
Why is it raining?

Keyword.txt contains:
stupid
noob

I want to filter out all lines that match if a keyword (line by line) in the keyboard.txt

So result.txt would be:
We go too the zoo.
Why is it raining?

Could anyone help me out?

windows-server-powershell

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2021-03-07T03:07:04.86Z

RichMatheisen-8856 answered Mar 7, '21 RichMatheisen-8856 commented Mar 7, '21

See how this works for you:

 $k = Get-Content C:\Junk\BadWordList.txt
 Get-Content C:\Junk\LinesToScrub.txt | 
     ForEach-Object{
         $badword = $false
         ForEach($w in $k){
             if ($_ -match "\b$w\b"){  # match whole word only...i.e., don't find "twat" in "saltwater"
                 $badword = $true
                 break
             }
         }
         if (-not $badword){
             $_
         }
     } | Out-File C:\Junk\NoBadWords.txt

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

StoreAdvs-5792 · Mar 07, 2021 at 01:05 PM

Hi,

thank you.

But this doesn't seem to be working for me. I tried to adjust a few things that might cause the issue but yeah.

0 ·

RichMatheisen-8856 StoreAdvs-5792 · Mar 07, 2021 at 04:14 PM

Thanks for that in-depth description of your problem. Good luck with your homework assignment!

Here are the files I tested with:
75076-lines.txt 75123-wordlist.txt

And here's the output:
75064-nobadwords.txt

1 ·

lines.txt (87 B)

wordlist.txt (12 B)

nobadwords.txt (80 B)

question