Find/replace string with carriage return and line feed in PowerShell

Question

Is there a way to have PowerShell find and replace a string (for example ~}}|{{E) with a carriage return and line feed (\r\nE)?

For example:

$filenames = @("E:\blergfest.csv")
foreach ($file in $filenames) {
    $outfile = "$file" + ".out"

    Get-Content $file | Foreach-object {
        $_ -replace '\~}}|{{E', '\r\nE' `
            -replace '\|\r\n', '\r\n'
    } | Set-Content $outfile
}

zdan · Answer 1 · 2013-03-08T19:42:23.490

3

To create a string that contains the control characters with carriage return and line feed, you would use double quotes and use the backtick character ` which is the powershell escape code. Like this:

"`r`nE"

edited Mar 08 '13 at 19:42

answered Mar 07 '13 at 23:51

zdan

28,667
7
60
71

score 2 · Accepted Answer · answered Mar 07 '13 at 23:48

2

How about this:

$filenames = @("E:\blergfest.csv")
foreach ($file in $filenames) {
    $outfile = "$file" + ".out"

    Get-Content $file | Foreach-object {
        $_ -replace '\~}}|{{E', "`r`nE" `
            -replace '\|\r\n', "`r`n"
    } | Set-Content $outfile
}

answered Mar 07 '13 at 23:48

mjolinor

66,130
7
114
135

1

Would it be too much to ask for you to have a statement like "in your replacement text, use the backtick `\`` instead of a backslash ``\``, like below:" (?) – Code Jockey Jun 11 '15 at 17:47

Find/replace string with carriage return and line feed in PowerShell

2 Answers2

Linked