如何修正PowerShell脚本输出冗余内容并添加自定义标识？

我写了一段PowerShell脚本，用来搜索指定目录下包含空值000的文件行，提取这些行到新文件后，将000替换为用户输入的内容。脚本核心功能正常，但输出文件存在冗余内容（包含Line表头、重复的命令行），同时需要在处理后的数据顶部添加自定义字符串THIS DATA HAS BEEN MODIFIED，期望输出格式如下：

THIS DATA HAS BEEN MODIFIED
--- aaa --- 5u7 --- ccc --- ddd
--- aaa --- 5u7 --- ccc --- ppp
--- aaa --- 5u7 --- ccc --- ddd
--- aaa --- 5u7 --- ccc --- zzz

当前使用的脚本 #

Set-ExecutionPolicy AllSigned
#Set Execution Policy

ls -r -Path C:\Users\Desktop\Data\Raw_data | sls '000' | select Line | 
Out-File C:\Users\Desktop\Data\Raw_data\Processed_data.txt

#Extract lines with null values and create a new file for this data

$file = @(get-item -Path 
\"C:\Users\Desktop\Data\Raw_data\Processed_data.txt\")

#Defines new file for for loop

$replacementStr = Read-Host -Prompt 'Input data in xxx format'

#Requests input from user to replace null values

$confirmation = Read-Host \"Is this correct? (y/n):\"

#Confirmation that format is correct

if ($confirmation -eq'n'){

    Remove-Item C:\Users\Desktop\Data\Raw_data\Processed_data.txt
    # exit 
}

#If format is incorrect delete created file and end the script

elseif ($confirmation -eq'y') {
    for ($file) 
        { 
            (Get-Content $file) | 
                    Foreach-object { $_ -replace '000' , $replacementStr}| 
                Set-Content $file 
                Write-Host Processed $file
                break
        }
}

#Search through the file for the 000 values and replace with the new user input string

当前错误输出 #

Line                                                                                                                                          
----                                                                                                                                          
ls -r -Path C:\Users\Desktop\Data\Raw_data | sls '5u7' | select Line | Out-File C:\Users\Desktop\Data\Raw_data\Processed_data.txt
               foreach-object { $_ -replace '5u7' , $replacementStr   } |                                                                     
--- aaa --- 5u7 --- ccc --- ddd                                                                                                               
--- aaa --- 5u7 --- ccc --- ppp                                                                                                               
--- aaa --- 5u7 --- ccc --- ddd                                                                                                               
--- aaa --- 5u7 --- ccc --- zzz                                                                                                               
ls -r -Path C:\Users\Desktop\Data\Raw_data | sls '5u7' | select Line | Out-File C:\Users\Desktop\Data\Raw_data\Processed_data.txt   

修正后的脚本 #

# 可选：设置执行策略（需管理员权限，建议按需启用）
# Set-ExecutionPolicy RemoteSigned -Scope CurrentUser -Force

# 定义路径参数
$sourceDir = "C:\Users\Desktop\Data\Raw_data"
$outputFile = Join-Path $sourceDir "Processed_data.txt"

# 1. 收集所有包含'000'的行（直接获取字符串，避免表头）
$matchedLines = Get-ChildItem -Recurse -Path $sourceDir | Select-String '000' | Select-Object -ExpandProperty Line

# 2. 获取用户输入并确认
$replacementStr = Read-Host -Prompt 'Input data in xxx format'
$confirmation = Read-Host "Is this correct? (y/n):"

if ($confirmation -eq 'n') {
    Write-Host "Operation cancelled."
    exit
}
elseif ($confirmation -eq 'y') {
    # 3. 替换内容并添加自定义头部
    $processedContent = @(
        "THIS DATA HAS BEEN MODIFIED"
        $matchedLines -replace '000', $replacementStr
    )

    # 4. 写入输出文件
    $processedContent | Set-Content $outputFile -Encoding UTF8
    Write-Host "Process completed. Output saved to: $outputFile"
}

关键修改说明 #

• 移除冗余表头：用Select-Object -ExpandProperty Line替代select Line，直接提取匹配行的字符串内容，避免输出对象表格的表头
• 简化流程：先收集所有匹配行到内存，确认用户输入后再统一处理写入，减少中间文件操作，避免意外写入命令行内容
• 修复语法错误：移除原脚本中多余的转义引号和错误的换行，修正文件路径定义
• 添加自定义头部：将指定字符串作为内容数组的首元素，确保写入文件时位于最上方
• 优化执行策略：将执行策略设置改为可选，并建议用RemoteSigned（更安全），指定CurrentUser范围避免管理员权限需求

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