如何使用PowerShell将数据添加到CSV的最后一列？

Question

我需要将数据添加到CSV文件的最后一列。我拥有的测试文件如下所示：

NAME,AGE,OFFICE,DEPT,SKILL
jack,24,IBM,Retail
tom,32,MS,BFSI
SAM,44,MGR,Test

我已经设法解析了CSV，但是在最后一列“SKILL”中添加数据是很困难的。要求是在每行的最后一列添加“Java”一词

NAME,AGE,OFFICE,DEPT,SKILL
jack,24,IBM,Retail,Java
tom,32,MS,BFSI,Java
SAM,44,MGR,Test,Java

请注意，添加到最后一列的值在各行之间保持不变。

Answer 1

您只需创建一个包含当前csv数据的对象，并使用字符串Java扩展该对象，如下所示：

$results = @() # Empty array to store new created rows in
$csv = Import-Csv "$PSScriptRoot\csvfile.csv"
foreach ($row in $csv) {
    $properties = [ordered]@{
        NAME   = $row.NAME
        AGE    = $row.AGE
        OFFICE = $row.OFFICE
        DEPT   = $row.DEPT
        SKILL  = "Java"
    }
    # insert the new row as an object into the results-array
    $results += New-Object psobject -Property $properties
}
# foreach-loop filled the results-array - export it as a CSV-file
$results | Export-Csv "new-file.csv" -NoTypeInformation

Answer 2

您可以更改导入对象的SKILL属性的值，并通过以下方式导出到CSV文件：

Import-Csv test.txt |
    ForEach-Object {$_.SKILL = "Java"; $_} |
    Export-Csv test_out.txt -NoTypeInformation

然而Export-Csv在值周围添加了引号，因此test_out.txt看起来像这样：

"NAME","AGE","OFFICE","DEPT","SKILL"
"jack","24","IBM","Retail","Java"
"tom","32","MS","BFSI","Java"
"SAM","44","MGR","Test","Java"

也许你应该简单地将"，Java"添加到每行第二行之后的末尾：

Get-Content test.txt |
    ForEach-Object { if($_.ReadCount -gt 1) { "$($_),Java" } else { $_ } } |
    Out-File test_out.txt