powershell trim - remove all characters after a string

Question

What would be the command to remove everything after a string (\test.something). I have information in a text file, but after the string there is like a 1000 lines of text that I don't want. how can I remove everything after and including the string.

This is what I have - not working. Thank you so much.

$file = get-item "C:\Temp\test.txt"

(Get-Content $file) | ForEach {$_.TrimEnd("\test.something\")} | Set-Content $file

LinkBerest - SO sold our work · Accepted Answer · 2015-03-17 02:07:59Z

6

Why remove everything after? Just keep everything up to it (I'm going to use two lines for readability but you can easily combine into single command):

$text = ( Get-Content test.txt | Out-String ).Trim() 
#Note V3 can just use Get-Content test.txt -raw
$text.Substring(0,$text.IndexOf('\test.something\')) | Set-Content file2.txt

Also, you may not need the Trim but you were using TrimEnd so added in case you want to add it later. )

edited Mar 17, 2015 at 2:07

answered Mar 17, 2015 at 1:57

LinkBerest - SO sold our work

1,3103 gold badges22 silver badges32 bronze badges

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

1 Comment

samsux Over a year ago

Brilliant, thank you so much.... works real good. without you guys I might as well go home and cry in the corner.

mjolinor · Accepted Answer · 2015-03-17 02:34:00Z

6

Using -replace

(Get-Content $file -Raw) -replace '(?s)\\test\.something\\.+' | Set-Content $file

edited Mar 17, 2015 at 2:34

answered Mar 17, 2015 at 1:23

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

5 Comments

samsux Over a year ago

removes the string and everything after on that line only. Doesn't delete the rest of the 999 lines. thanks for helping me.

mjolinor Over a year ago

Did you add that -Raw switch to Get-Content?

samsux Over a year ago

sure did ------ $text = ( Get-Content "file.txt" -raw | Out-String ).Trim() $text.Substring(0,$text.IndexOf('$text = ( Get-Content "file.txt" -raw | Out-String ).Trim() $text.Substring(0,$text.IndexOf('Folder: \Microsoft')) | Set-Content "file.txt"')) | Set-Content "file.txt"

LinkBerest - SO sold our work Over a year ago

You need to turn on the singleline flag (?s) so the regex matches newlines and it's harder to write those with powershell would look something like: $text -replace "(?s)\\test\.something\\.*\r\n.*","" or using `n for newline

mjolinor Over a year ago

@JGreenwell Good catch!. In this instance the newlines don't matter. They'll all get included in the trailing ',+'.

Collectives™ on Stack Overflow

powershell trim - remove all characters after a string

2 Answers 2

1 Comment

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Related