Powershell Export-Csv -Append in new column

Question

Just want to ask how to Export the data in existing CSV file in new column. I have this following code.

$Ex=Compare-Object $ImportWin7 $Importafipd1 -includeequal 

$Ex | Select-Object SideIndicator | Export-Csv -Append -Force  -NoTypeInformation "C:\NotBackedUp\EndpointAudit\Win7machinetest2.csv"

but it appears that the Data from $EX was appended not on the first row of the column.

Consider adding some sample data that demonstrates the problem. — vonPryz
– vonPryz, Commented Dec 14, 2016 at 6:03
You can't just add an additional column to existing csv document. You would want recreate it again with required number of columns. — Kirill Pashkov
– Kirill Pashkov, Commented Dec 14, 2016 at 6:12

Utkarsh Dubey · Accepted Answer · 2020-10-28 04:56:28Z

3

You can't just add an additional column to existing csv document. You would want to recreate it again with number of columns you need. Like so:

$ExistingCSV = Import-Csv "C:\NotBackedUp\EndpointAudit\Win7machinetest2.csv"

$Ex=Compare-Object $ImportWin7 $Importafipd1 -includeequal | Select-Object SideIndicator

$obj = @()
$i = 0

foreach ($row in $ExistingCSV)
{
    $item = New-Object PSObject -ArgumentList $row
    $item | Add-Member -MemberType NoteProperty extra_column -Value $Ex[$i]
    $obj += $item
    $i++
}
$obj | Export-Csv -Append -Force  -NoTypeInformation "C:\NotBackedUp\EndpointAudit\Win7machinetest2.csv"

edited Oct 28, 2020 at 4:56

Utkarsh Dubey

78412 silver badges33 bronze badges

answered Dec 14, 2016 at 6:36

Kirill Pashkov

3,2461 gold badge19 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell Export-Csv -Append in new column

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related