PowerShell导出文本内容为CSV未生成预期结果的问题排查

原文件内容 #

id user        mart  desc                                                                                                
 -- ----        ----- --------                                                                                                
  1 test_1          3 test result 1...
  2 test_2          3 test result 2

用户执行的命令 #

Get-Content .\test | ConvertTo-Csv -NoTypeInformation | Out-File txt.csv

预期CSV输出 #

id,user,mart,desc
1,test_1,3,test result 1
2,test_2,3,test result 2

实际错误输出 #

"PSPath","PSParentPath","PSChildName","PSDrive","PSProvider","ReadCount","Length"
"C:\test","C:\question","test","C","Microsoft.PowerShell.Core\FileSystem","1","126"
"C:\test","C:\question","test","C","Microsoft.PowerShell.Core\FileSystem","2","126"
"C:\test","C:\question","test","C","Microsoft.PowerShell.Core\FileSystem","3","126"
"C:\test","C:\question","test","C","Microsoft.PowerShell.Core\FileSystem","4","126"

问题原因 #

Get-Content读取文件后输出的是字符串对象，每个字符串都附带PowerShell文件系统的元数据属性（如PSPath、ReadCount等）。直接将这些对象传给ConvertTo-Csv时，cmdlet会把字符串对象的元数据转换成CSV，而非解析字符串里的表格内容，这就导致输出完全不符合预期。

解决方案 #

方案1：使用ConvertFrom-String解析固定列宽表格（PowerShell 5.0+支持） #

该cmdlet可以自动识别列宽格式的表格，将其转换为PowerShell对象，再转成CSV：

# 跳过前两行（表头和分隔线），解析为对象后转换为CSV
Get-Content .\test | Select-Object -Skip 2 | ConvertFrom-String -PropertyNames id, user, mart, desc | ConvertTo-Csv -NoTypeInformation | Out-File txt.csv -Encoding utf8

方案2：正则表达式手动解析行内容 #

如果对表格格式有精确控制，用正则匹配每个字段更可靠：

# 读取文件并跳过前两行无关内容
$lines = Get-Content .\test | Select-Object -Skip 2
# 初始化CSV表头
$csvContent = @("id,user,mart,desc")

foreach ($line in $lines) {
    # 匹配行中的数字ID、用户名、mart值、以及描述内容
    $matchResult = [regex]::Match($line, '^\s*(\d+)\s+(\S+)\s+(\d+)\s+(.*)$')
    if ($matchResult.Success) {
        $id = $matchResult.Groups[1].Value
        $user = $matchResult.Groups[2].Value
        $mart = $matchResult.Groups[3].Value
        $desc = $matchResult.Groups[4].Value
        # 将字段拼接为CSV行
        $csvContent += "$id,$user,$mart,$desc"
    }
}

# 写入CSV文件
$csvContent | Out-File txt.csv -Encoding utf8

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