Powershell: Error while replacing the sub-string in a file

Question

I am trying to replace some of the sub-strings with some values across multiple files. I have written this code to do so.

$dirPath = 'C:\repos\sync_cpc_cva\ExpressV2\Parameters\AG08\KeyVault'
$ConfigPath = 'C:\repos\sync_cpc_cva\config.json'

$lookupTable = @{}
(Get-Content -Raw -Path $configPath | ConvertFrom-Json).psobject.properties | Foreach { $lookupTable[$_.Name] = $_.Value }

Get-ChildItem -Path $dirPath -Recurse -Filter *.json | 
Foreach-Object {
    
    Get-Content $_.FullName | ForEach-Object {
        $line = $_
        
        $lookupTable.GetEnumerator() | ForEach-Object {
            
            if($line -match $_.Key) {
                
                $line = $line -replace $_.Key, $_.Value
                
            }
        }
        $line
    } | Set-Content -Path $_.FullName
}

If I print the content, it has replaced all the values correctly, however, it is unable to set the contents into the same file. And I am getting following error while running the code :

Set-Content : The process cannot access the file
'C:\repos\sync_cpc_cva\ExpressV2\Parameters\AG08\KeyVault\KeyVault.USNat.json' because it is being used by another process.
At C:\repos\sync_cpc_cva\filltest.ps1:22 char:9
+     } | Set-Content -Path $_.FullName
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Set-Content], IOException
    + FullyQualifiedErrorId : System.IO.IOException,Microsoft.PowerShell.Commands.SetContentCommand

Any idea how can I replace the sub-strings in the same file?

Vikas Gupta · Accepted Answer · 2020-07-07 12:34:20Z

1

You have several inner foreach-object loops, so you modify the $_ operator while being used. I dont think this can work. Revolve it like this:

$lookupTable = @{}
(Get-Content -Raw -Path $configPath | ConvertFrom-Json).psobject.properties | Foreach { $lookupTable[$_.Name] = $_.Value }

$files = Get-ChildItem -Path $dirPath -Recurse -Filter *.json

foreach ($file in $files) {
    $content = Get-Content $file.FullName
    for($i=0;$i -lt $content.length; $i++) {
        $lookupTable.GetEnumerator() | ForEach-Object {
            $content[$i] = $content[$i] -replace $_.Key, $_.Value
        }

    }
    $content | Set-Content $file.FullName

}

edited Jul 7, 2020 at 12:34

Vikas Gupta

11k5 gold badges39 silver badges45 bronze badges

answered Jul 7, 2020 at 9:57

Farbkreis

6444 silver badges12 bronze badges

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

3 Comments

Vikas Gupta Over a year ago

Thanks it worked. However, while pushing the changes to the git, getting this error: Binary files a/ExpressV2/Parameters/AG08/KeyVault/KeyVault.USNat.json and b/ExpressV2/Parameters/AG08/KeyVault/KeyVault.USNat.json differ

Vikas Gupta Over a year ago

this is probably due to the fact, we are creating a new file with the same name. Hence, both of them have different checksum. Therfore, git is unable to push the changes. Any idea how we can make changes in the same file?

Vikas Gupta Over a year ago

Instead of Out-File, we can use Set-Content. We won't get any issue afterwards.

Collectives™ on Stack Overflow

Powershell: Error while replacing the sub-string in a file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related