How to do replace on multiple files with powershell

Question

The aim is replace ",," with blank in the text files.

The below works on single file:

$path = "C:\Users\ThompsonHo\Desktop\testing\F181RMR CAN.txt"
$word = ",,"
$replacement = ""
$text = get-content $path 
$newText = $text -replace $word,$replacement
$newText > $path

I try to make it handle for multiple files but fail, How to do replace on multiple files with powershell?

$path = "C:\Users\ThompsonHo\Desktop\testing\F18*.txt"
$word = ",,"
$replacement = ""
$text = get-content $path 
$newText = $text -replace $word,$replacement
$newText > $path

this is work for my case. Get-ChildItem C:\Users\ThompsonHo\Desktop\testing *.txt -recurse | Foreach-Object { $c = ($_ | Get-Content) $c = $c -replace ',,','' [IO.File]::WriteAllText($_.FullName, ($c -join "rn")) } — Thompson Ho
– Thompson Ho, Commented May 15, 2018 at 2:46

Daniel Mann · Accepted Answer · 2018-05-15 02:19:50Z

1

You have to retrieve a list of files, then iterate over the list.

You can retrieve files that match a pattern with Get-ChildItem (although Get-Item would also work in this situation):

$files = Get-ChildItem "C:\Users\ThompsonHo\Desktop\testing\F18*.txt"

That gives you an array of FileInfo. You can iterate over a collection with foreach.

foreach ($file in $files) {
    $file.FullName
}

$file.FullName at this point will be the full path to the file.

Your existing working solution for a single file should be easy to adapt.

answered May 15, 2018 at 2:19

Daniel Mann

59.5k13 gold badges106 silver badges128 bronze badges

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

Comments

qdl · Accepted Answer · 2018-05-15 04:05:39Z

0

$p="C:\temp"
$cs=Get-ChildItem -Path $p 

foreach($c in $cs)
{
    $t=Get-Content -Path $c.FullName -Raw 
    #$t  -replace ",,",""|Out-File -FilePath  $c.FullName -NoNewline
    Set-Content -Path $c.FullName -Value ($t  -replace ",,","") -NoNewline
}

answered May 15, 2018 at 4:05

qdl

112 bronze badges

Comments

Esperento57 · Accepted Answer · 2018-05-15 06:25:13Z

0

try this :

Get-ChildItem "c:\temp\F18*.txt" | %{$file=$_.FullName; (Get-Content $file).Replace(',,', ',') | Out-File $file }

answered May 15, 2018 at 6:25

Esperento57

17.6k6 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

How to do replace on multiple files with powershell

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related