PowerShell中CSV文件追加操作异常问题求助

问题背景 #

我正在开发一个处理多CSV文件的程序，已生成包含首个CSV数据及表头的输出文件$AF，尝试将另一个CSV文件$AFw追加到$AF中。调试时AppendNew变量内容显示正常，但执行代码后输出结果不符合预期，需要定位并解决问题。

相关信息 #

$AFw的首行内容 #

"08-01-2023 09:00:00","08-02-2023 09:00:00","1","DAYTONA","104.5","1045","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""

用于追加的PowerShell代码 #

$Append = Import-Csv $AF
$AppendNew = Import-Csv $AFw 

# 追加源CSV内容到目标CSV
$Append1 = $Append + $AppendNew

# 将更新后的数据导出到目标CSV文件
$Append1 | Export-Csv -Path $AF -NoTypeInformation

关键行内容 #

• 原$AF的末行：

"12/31/2023 09:00:00","01-01-2024 00:00:00","BRANDY BRANCH","9990000","26,138.0","0","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","10.451000"

• 追加后$AF的异常前两行：

,,,,,,,"1",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,"1",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

问题原因与解决办法 #

核心原因 #

两个CSV文件的表头结构不匹配：Import-Csv会根据目标文件$AF的表头生成对象，当$AFw的列数、列名或列顺序与$AF不一致时，合并时数据会错位，仅填充匹配列，其余列留空，最终导出后就会出现大量空值的异常行。

具体解决步骤 #

1. 统一表头结构
   先确认$AF的表头，再确保$AFw使用完全相同的表头：

   # 获取$AF的表头列名
   $targetHeaders = (Get-Content $AF -First 1) -split ',' | ForEach-Object { $_.Trim('"') }
   # 用目标表头导入$AFw（如果$AFw本身没有表头）
   $AppendNew = Import-Csv $AFw -Header $targetHeaders
   

2. 对齐列顺序
   如果$AFw有表头但列顺序与$AF不同，需要强制对齐列顺序后再合并：

   $Append = Import-Csv $AF
   $AppendNew = Import-Csv $AFw | Select-Object $Append[0].PSObject.Properties.Name
   

3. 合并并导出
   完成表头统一和列对齐后，重新执行合并导出：

   $Append = Import-Csv $AF
   $targetHeaders = $Append[0].PSObject.Properties.Name
   $AppendNew = Import-Csv $AFw -Header $targetHeaders | Select-Object $targetHeaders
   ($Append + $AppendNew) | Export-Csv -Path $AF -NoTypeInformation -Encoding UTF8
   

4. 高效追加备选方案
   如果确认两个CSV文件格式完全一致（表头、编码、分隔符），可以直接跳过表头追加文本内容，效率更高：

   # 跳过$AFw的首行（表头），直接追加数据行到$AF
   Get-Content $AFw | Select-Object -Skip 1 | Add-Content $AF
   

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