<div>
Please post the code you are currently developing.
</div>

Software Developer

<div>
This should do it.. 
 

<pre><code class="code-10 nolinks" id="code-20-43073494-1">$LookupFilePath = 'c:\temp\lookuppairs.txt '
$UpdateDirectory = 'c:\TestFiles'
$UpdateFilter = '*.sql'

$Lookups = @{}
Get-Content -Path $LookupFilePath | foreach-object {
 $thisLine = $_.split(',')
 $Lookups.Add($thisLine[0], $thisLine[1])
}
$FileList = Get-ChildItem -path $UpdateFilter -Filter $UpdateFilter
foreach ($file in $FileList) {
 $FileContents = Get-Content -Path $file.fullname -Raw
 foreach ($entry in $Lookups.keys) {
 #specifically using -Replace, because it is not case-sensitive
 $FileContents = $FileContents -Replace $entry, $Lookups.$entry 

 #If you are sure your lookup values will be the correct case, then you can swap it with this line instead.
 #$FileContents = $FileContents.Replace($entry, $Lookups.$entry)
 }
 Set-Content -Path $file.FullName -Value $FileContents -Force
}
</code></pre>
 
You could do more using the RSJobs module, or the ThreadJobs module to run this in parallel. 
 
Coralon
</div>

<div>
<div class="content wysiwyg-content">
I need a PowerShell script to replace A with B in multiple files. However, A and B are coming in from a separate file and contain comma-delimited pairs. A represents what to replace and B is what to replace it with. 
 
The files to search and replace are all in a specific directory, and all same filetype (e.g. *.SQL). 
 
So, if the file containing the match and replace pairs contains: 
Apples,Oranges 
Cows,Horses 
Yellow,Blue 
 
And I have 5 files to search, then for each file I would replace Apples with Oranges, Cows with Horses and Yellow with Blue. 
 
Note: The comma-delimited pair file could contain up to 200 pairs. 
 
I've gotten to where I'm reading the contents of the comma-delimited pairs file into an array but I'm fidgeting with proper nesting of all my loops and how to replace each pair within each file.
</div>
</div>

I need a PowerShell script to replace A with B in multiple files. However, A and B are coming in from a separate file and contain comma-delimited pairs. A represents what to replace and B is what to replace it with.

The files to search and replace are all in a specific directory, and all same filetype (e.g. *.SQL).

So, if the file containing the match and replace pairs contains:
Apples,Oranges
Cows,Horses
Yellow,Blue

And I have 5 files to search, then for each file I would replace Apples with Oranges, Cows with Horses and Yellow with Blue.

Note: The comma-delimited pair file could contain up to 200 pairs.

I've gotten to where I'm reading the contents of the comma-delimited pairs file into an array but I'm fidgeting with proper nesting of all my loops and how to replace each pair within each file.

Using PowerShell to replace text in a set of Files

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.