多文件差异化文本替换后内容未保存问题求助

Hey there! Let's work through this problem together. It sounds like you've got a solid setup with an Excel config for targeted text replacements across files, but your PowerShell scripts aren't saving the changes—and you're dealing with files that have special characters in their names. Let's break this down and fix it.

First: Why aren't your changes saving? #

The most common culprit here is that many folks do the text replacement in memory but forget to write the modified content back to the file. Other issues can include incorrect file path handling (especially with special characters) or encoding mismatches that cause silent failures.

Let's fix this with two approaches #

Depending on whether you want to use your Excel config directly, or stick with separate scripts for different file groups, here are working solutions:

Option 1: Use your Excel config for all replacements

First, you'll need the ImportExcel module to easily read your Excel table (it's way simpler than dealing with COM objects). Install it if you haven't already:

Install-Module -Name ImportExcel -Scope CurrentUser -Force

Then, here's a script that reads your two-column (or multi-column) config and applies replacements per file:

# 1. Read your Excel config (adjust column names and file path to match yours)
$config = Import-Excel -Path "C:\your\config\path\replacements.xlsx"

# 2. Loop through each rule in the config
foreach ($rule in $config) {
    # Handle special filenames by resolving the full path
    try {
        $filePath = Resolve-Path -Path $rule.FileName -ErrorAction Stop
    }
    catch {
        Write-Warning "Could not find file: $($rule.FileName). Skipping."
        continue
    }

    # 3. Read the file content as a single string (avoids line-by-line issues)
    $content = Get-Content -Path $filePath -Raw -Encoding UTF8

    # 4. Apply the replacement (escape old value to handle regex special chars like .*+?)
    $updatedContent = $content -replace [regex]::Escape($rule.OldValue), $rule.NewValue

    # 5. Write the modified content BACK to the file
    Set-Content -Path $filePath -Value $updatedContent -Encoding UTF8

    Write-Host "Successfully updated: $filePath"
}

Option 2: Separate scripts for different file groups

If you prefer keeping script1 and script2 for distinct file sets, here's how to fix them to save changes and handle special filenames:

Script 1 (for files where "AA" → "E1", "A1" → "P4"):

# Define your replacement rules
$replacements = @{
    "AA" = "E1"
    "A1" = "P4"
}

# Target files (use Get-ChildItem to handle special filenames automatically)
$targetFiles = Get-ChildItem -Path "C:\path\to\your\first\file\group\*" -File

foreach ($file in $targetFiles) {
    # Read full content
    $content = Get-Content -Path $file.FullName -Raw -Encoding UTF8

    # Apply all replacements
    foreach ($oldValue in $replacements.Keys) {
        $content = $content -replace [regex]::Escape($oldValue), $replacements[$oldValue]
    }

    # Save the changes
    Set-Content -Path $file.FullName -Value $content -Encoding UTF8
    Write-Host "Updated: $($file.FullName)"
}

Script 2 (for files where "AA" → "P1", "A1" → "E1"):

# Define your replacement rules
$replacements = @{
    "AA" = "P1"
    "A1" = "E1"
}

# Target files
$targetFiles = Get-ChildItem -Path "C:\path\to\your\second\file\group\*" -File

foreach ($file in $targetFiles) {
    $content = Get-Content -Path $file.FullName -Raw -Encoding UTF8

    foreach ($oldValue in $replacements.Keys) {
        $content = $content -replace [regex]::Escape($oldValue), $replacements[$oldValue]
    }

    Set-Content -Path $file.FullName -Value $content -Encoding UTF8
    Write-Host "Updated: $($file.FullName)"
}

Key fixes to note: #

• -Raw parameter: Reads the entire file as one string, so replacements work across lines and don't break formatting.
• Set-Content: This is the critical step that writes your modified content back to the file—don't skip it!
• [regex]::Escape(): Ensures that if your old values have regex special characters (like ., *, or ?), they're treated as literal text instead of regex patterns.
• Get-ChildItem: Automatically handles filenames with spaces, parentheses, &, or other special characters by using the full file path.
• Encoding: Specifying -Encoding UTF8 prevents unexpected character garbling when saving.

内容的提问来源于stack exchange，提问作者user3807741