PowerShell script to search and replace text

Question

Hello I have a script that searches for a matching string, then replace it

I want to replace all occurrence of "6.0.0.0.2010 Wave Embedded 6.0 (2010)" with "6.0.0.0.XXXX Wave Embedded 6.0 (XXXX)"

I want to match strings that match exactly that, however if i modify the 6.0.0.0.XXXX then it deletes everything after that..

my script :

(Get-Content C:\Users\gadmin\Desktop\temp\test.txt) | ForEach-Object { $_ -replace '6.0.0.0.*$', '6.0.0.0.XXXX' } | Set-Content C:\Users\gadmin\Desktop\temp\test1.txt

Worked for me without the space after the $ in the replace. "Embedded 6.0 (2010)" | % { $_ -replace "^Embedded 6.0.*$", "Embedded 6.0 (XXXX)" } — AtomicFireball
– AtomicFireball, Commented Dec 8, 2016 at 20:32

score 3 · Accepted Answer · 2016-12-08 22:11:05Z

3

I had no problem with my teststring, is the occurence always the same?

"6.0.0.0.2010 Wave Embedded 6.0 (2010)"| ForEach {
    $_ -replace '6.0.0.0.2010 Wave Embedded 6.0 (2010)', 
                '6.0.0.0.XXXX Wave Embedded 6.0 (XXXX)'}

So this should work also (you may insert a new line after a pipe or opening curly bracket):

$FileIn = "C:\Users\gadmin\Desktop\temp\test.txt"
$FileOut= "C:\Users\gadmin\Desktop\temp\test1.txt"

[RegEx]$Search = '6.0.0.0.\d{4} Wave Embedded 6.0 \(\d{4}\)'
Get-Content $FileIn -Raw| ForEach {
        $_ -replace $Search, '6.0.0.0.XXXX Wave Embedded 6.0 (XXXX)'}|
Set-Content $FileOut

edited Dec 8, 2016 at 22:11

answered Dec 8, 2016 at 21:38

user6811411

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

4 Comments

user5192051 Over a year ago

ahhh i wasn't clear in my question the 2010 in the string is the variable and will not be the same. However, i just copied and paste your solution and it did not modify, if anything it should replace that line...i wonder where i went wrong

user6811411 Over a year ago

So what are you searching for? Four digits will be represented by \d{4}

user5192051 Over a year ago

another thing since there are mutiple entries of 6.0.0.0 in my text file, how do i constrained this match '6.0.0.0.\d{4}' to have to be followed by 'Wave Embedded'

user6811411 Over a year ago

There was still a flaw, the parentheses in the search have to be escaped because they have a special meaning in a RegEx (capture group). I edited my script, It should work now.

Collectives™ on Stack Overflow

PowerShell script to search and replace text

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related