如何用PowerShell找到Base后提取Test2/3/4字符串并生成报告

需求场景 #

从目标文件中定位每个Base:开头的行，匹配其后续对应的Test2:、Test3:、Test4:行，将每组关联内容合并成结构化报告，但原有代码无法稳定输出预期结果。

文件数据示例 #

Base: some text
some line here
some line here
Test2: another text 
Test3: other text
Test4: different text
some lines here
some lines here
some lines here
Base: some text
some line here
some line here
Test2: another text 
Test3: other text
Test4: different text
some lines here
some lines here
some lines here
some lines here
.............
.............

现有问题代码 #

$data = Get-Content $file
$req_data = $data |where {$_.Contains("Base") -or $_.Contains("Test2") -or $_.Contains("Test3") -or $_.Contains("Test4")}
$bases_data = $data |where {$_.Contains("Base")}
foreach ($basedata in $bases_data)
{
   $find_alias = ($req_data |select-string "^${basedata}$" -context (0.10)).Context.PostContext
   $final_data = "" | select Base, Test2, Test3, Test4
   $temp.Base = $basedata
   $temp.Test2 = ($find_alias |select-string "Test2").Tostring()
   $temp.Test3 = ($find_alias |select-string "Test3").Tostring()
   $temp.Test4 = ($find_alias |select-string "Test4").Tostring()
   $temp
}

代码问题点 #

1. 用$req_data过滤后的数据做匹配，打乱了原文件的行顺序关联，没法准确找到当前Base对应的后续Test行
2. 变量$temp未初始化就直接赋值，会触发报错
3. select-string的-context参数格式错误，应该用逗号分隔（0,10）而非点号
4. 用^${basedata}$做全匹配，容易因为行尾空格、换行符等细节导致匹配失败

修正后的代码 #

$file = "你的文件路径"
# 读取整个文件并按Base:分割成独立块
$dataBlocks = Get-Content $file -Raw | Split-String -Delimiter "Base:" | Where-Object { $_ -ne "" }

foreach ($block in $dataBlocks) {
    # 拼接回完整的Base行内容
    $baseLine = "Base:" + $block.Split("`n")[0].Trim()
    # 从当前块中提取对应的Test行
    $test2 = ($block | Select-String "Test2:.*").Matches.Value
    $test3 = ($block | Select-String "Test3:.*").Matches.Value
    $test4 = ($block | Select-String "Test4:.*").Matches.Value

    # 生成结构化对象输出
    [PSCustomObject]@{
        Base  = $baseLine
        Test2 = $test2
        Test3 = $test3
        Test4 = $test4
    }
}

代码说明 #

• 用Get-Content -Raw一次性读取整个文件，按Base:分割成独立块，每个块对应一个Base及其后续所有内容，确保关联关系不丢失
• 从每个块里精准提取对应的Test行，避免跨块匹配错误
• 用[PSCustomObject]生成结构化数据，直接输出就是规整的表格格式，符合报告需求

预期输出 #

Base                Test2                Test3              Test4
----                -----                -----              -----
Base: some text     Test2: another text  Test3: other text  Test4: different text
Base: some text     Test2: another text  Test3: other text  Test4: different text

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