-Replace and regex in powershell

Question

I am trying to find a way to replace the same string with different values in a text file using powershell. The word is the same with special characters (e.g "[Placeholder]"). This is for a .json file that looks something similar to this.

Line1: 
Line2:
Line3: [Placeholder]
Line4:  [Placeholder]

The idea is to change the string [Placeholder] on line 3 with the version and line 4 with the current date. When i try to do this with the following code it automatically replaces both [Placeholder]'s with the version and i am struggling to find a way to have line 3 be the version and 4 the date

$currentVersion = "v.1.2.3.4"
$currentDate =  "08/08/2021"
$original_file = 'C:\Users\samue\Desktop\D\V1\hehehehe.txt'
(Get-Content $original_file) | Foreach-Object {
    $_ -replace ([regex]::Escape('[Placeholder]')), $currentVersion `
      -replace ([regex]::Escape('[Placeholder]')), $currentDate
    } | Set-Content $original_file

As you can see it will replace all [placeholder]'s with $currentVersion because that is the first thing it finds but I need some help on maybe how to use regex to match and then replace the word

Line1: 
Line2:
Line3: v.1.2.3.4
Line4:  v.1.2.3.4

If he original file is in JSON format, could you not just use ConvertFrom-Json to get it in object format, update the appropriate properties, then save with ConvertTo-Json? — boxdog
– boxdog, Commented Aug 10, 2021 at 8:55
@boxdog Thanks this solved my issue ! leaving the answer below. PS: the only thing that i might need to do is to not use two if statements for this and use -and but i need to check on that (very new to PS!). — Samuel Van Bladel
– Samuel Van Bladel, Commented Aug 10, 2021 at 9:40

Samuel Van Bladel · Accepted Answer · 2021-08-10 09:45:12Z

0

Thanks to @boxdog for mentioning ConvertFrom-Json With that I found the following Stack overflow post :

$currentDate =  "08/08/2021"
$a = Get-Content 'C:\Users\samue\Desktop\D\V1\hehehehe.json' -raw | ConvertFrom-Json
$a.update | % {if($_.Version -eq '[Placeholder]'){$_.Version=$currentVersion} }
$a.update | % {if($_.date -eq '[Placeholder]'){$_.date=$currentDate}}
$a | ConvertTo-Json -depth 32| set-content 'C:\Users\samue\Desktop\D\V1\hehehehe.json'

Only thing would be to not use 2 if statements but i have to learn a bit more PS to do that !

answered Aug 10, 2021 at 9:45

Samuel Van Bladel

671 gold badge4 silver badges11 bronze badges

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

Comments

C. Aknesil · Accepted Answer · 2021-08-10 09:52:18Z

0

You can use "capture" property of -replace:

> $str = "Line3: [Placeholder]`nLine4:  [Placeholder]"

> $str -replace '(Line[0-9]+: )\[Placeholder\]', '$1 v.1.2.3.4'                                         
Line3:  v.1.2.3.4
Line4:  [Placeholder]

> $str -replace '(Line[0-9]+:  )\[Placeholder\]', '$1 v.1.2.3.4'
Line3: [Placeholder]
Line4:   v.1.2.3.4

The content in parenthesis is captured and inserted via $1.

answered Aug 10, 2021 at 9:52

C. Aknesil

4492 silver badges4 bronze badges

Collectives™ on Stack Overflow

-Replace and regex in powershell

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related