Replace the content of a textfile with a regex in powershell

RegexPowershell

Regex Problem Overview


I have a simple textfile and I need a powershell script to replace some parts of the file content.

My current script is the following:

$content = Get-Content -path "Input.json"

$content -Replace '"(\d+),(\d{1,})"', '$1.$2' |  Out-File "output.json"

Is it possible to write it in one line without the content variable, like this?

Get-Content -path "Input.json" | ??? -Replace '"(\d+),(\d{1,})"', '$1.$2' |  Out-File "output.json"

I don't know how I can use the output of the first get-content commandlet in the second command without the $content variable? Is there an automatic powershell variable

Is it possible to do more replacements than one in a pipeline.

Get-Content -path "Input.json" | ??? -Replace '"(\d+),(\d{1,})"', '$1.$2' | ??? -Replace 'second regex', 'second replacement' |  Out-File "output.json"

Regex Solutions


Solution 1 - Regex

Yes, you can do that in one line and don't even need a pipeline, as -replace works on arrays like you would expect it to do (and you can chain the operator):

(Get-Content Input.json) `
    -replace '"(\d+),(\d{1,})"', '$1.$2' `
    -replace 'second regex', 'second replacement' |
  Out-File output.json

(Line breaks added for readability.)

The parentheses around the Get-Content call are necessary to prevent the -replace operator being interpreted as an argument to Get-Content.

Solution 2 - Regex

> Is it possible to write it in one line without the content variable, like this?

Yes: use ForEach-Object (or its alias %) and then $_ to reference the object on the pipeline:

Get-Content -path "Input.json" | % { $_ -Replace '"(\d+),(\d{1,})"', '$1.$2' } |  Out-File "output.json"

> Is it possible to do more replacements than one in a pipeline.

Yes.

  1. As above: just adding more Foreach-Object segments.

  2. As -replace returns the result, they can be chained in a single expression:

     ($_ -replace $a,$b) -replace $c,$d
    

    I suspect the parentheses are not needed, but I think they make it easier to read: clearly more than a few chained operators (especially if the match/replacements are non-trivial) will not be clear.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionJan BaerView Question on Stackoverflow
Solution 1 - RegexJoeyView Answer on Stackoverflow
Solution 2 - RegexRichardView Answer on Stackoverflow