Replace date and save json not working

Question

How to replace target date to today date using powershell
I have tried out all find and replace technique but date is not saved

$today='{:0:yyyy-MM-dd}' -f (get-date)
$file="c:\temp\sample.json";(gc $file| convertfrom-json)|
Foreach-Object {$_ -replace ""target" : (\d+)/(\d+)/(\d+)", ""target" : $today"} | Set-Content $file

code in the file c:\temp\sample.json is

{ 
 "response": [
   {
 "id":"11",
 "acc":"me",
 "dateMain":{
        "start": "2020-22-01",
        "target": "2020-22-02"
                }
   },
 "majorreldate" : [
 {
 "start": "2020-22-01",
 "target": "2020-22-02"
 }
 ],
 "minorreldate" :{
 "start": "2020-22-01",
 "target": "2020-22-02"
 }
  ]
}

Answer 1

It would be nice if the JSON you posted was in the correct format! Also, there's an extra ":" in your date format string.

Treating the data as a plain text file, this will work:

$x = Get-Content C:\junk\j.json -Raw
$today='{0:yyyy-MM-dd}' -f (get-date)
$y = $x -creplace '"target": "\d\d\d\d-\d\d-\d\d"', """target"": ""$today"""

Answer 2

Hi,

Hope this works for you

$today='{0:yyyy-MM-dd}' -f (get-date)  
$file='c:\temp\sample.json'  
(Get-Content $file) -replace '(?<="target":\s+")\d{4}-\d{2}-\d{2}',$today  

Best Regards，
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.