Delete specific text from a file with PowerShell

Question

I need to delete/replace specific text which is written on more rows and has blank rows between the lines of text.

For example:

some text

text 1

other text

text 1

I need to delete:

other text

text 1

The result will be:

some text

text 1

Right now I have this: (Get-Content file.txt) -notmatch "other textrntext 1" | Out-File file.txt

Possible duplicate: stackoverflow.com/questions/24326207/… — Peter Schneider
– Peter Schneider, Commented Mar 13, 2019 at 9:01
It's different. I need to delete a section wich have empty rows. — ARB
– ARB, Commented Mar 13, 2019 at 9:13
You missed to show the code you have so far. You might read the following help How do I ask a good question? and How to create a Minimal, Complete, and Verifiable example. — Olaf
– Olaf, Commented Mar 13, 2019 at 9:19
The sample should get you started... use the get-content cmdlet with the -raw parameter then you can use \r\n inside the -pattern parameter of select-string to match the newline. As stated by Olaf you should provide some code. — Peter Schneider
– Peter Schneider, Commented Mar 13, 2019 at 9:25
Right now I have this : (Get-Content file.txt) -notmatch "other textrntext 1" | Out-File file.txt . It's not working like this, something it's wrong with how i use the "rn". — ARB
– ARB, Commented Mar 13, 2019 at 9:36

AdminOfThings · Accepted Answer · 2019-03-13 13:54:14Z

0

There are a number of ways to approach this.

Grabbing the first three lines of the text file:

(Get-Content File.txt)[0..2]

Selecting the string you wish to output:

((Get-Content File.txt -raw) | Select-String -pattern "(?s)some text.*?text 1").matches.value

Determining line numbers of bad lines and then excluding them:

$File = Get-Content File.txt
$FirstBadLine = $File.IndexOf("other text")
$LastBadLine = ($file | select -skip $firstbadline).IndexOf("text 1")+$firstbadline
$file[0..($firstbadline-1)],$file[($lastbadline+1)..$file.count]

Determine First Bad Line and skipping a known number of lines from there:

$File = Get-Content File.txt
$NumberOfBadLines = 5
$FirstBadLine = $File.IndexOf("other text")
$file[0..($firstbadline-1)+($firstbadline+$NumberOfBadLines)..$file.count] | Set-Content File.txt

edited Mar 13, 2019 at 13:54

answered Mar 13, 2019 at 11:16

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

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

3 Comments

ARB Over a year ago

I tried to give an simpler example. What I have is one file with a lot of lines and I need to delete a section wich have 5 lines ( 3 liness with text and 2 empty lines between). I don't know the numer on which the lines are.

AdminOfThings Over a year ago

I think my last example can do what you want.

ARB Over a year ago

Your last example saved me. I knew the third row and the fifth and I searched the third row and did $firstBadLine-2. Thank you !

Collectives™ on Stack Overflow

Delete specific text from a file with PowerShell

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related