Powershell - export csv value into specific column

Question

Having some issues with the syntax. I'm trying to copy the variable value into another csv column.

$file1 = import-csv C:\temp\csv1.csv
$file2 = import-csv C:\Temp\csv2.csv
$file3 = import-csv C:\Temp\csv3.csv

foreach ($line in $file1) {
foreach ($row in $file2) {
    if ($line.col1 -eq $row.col1){
        #this is the part im having issues with:
         $row.col2 = $line.col3 | Export-Csv #???
        }
    }
  }

$row is a reference to an object in $file2. When you update $row, $file2 is automatically updated. Therefore, you can just wait until you have made all your updates. Then export to CSV at the end --> $file2 | Export-Csv .... — AdminOfThings
– AdminOfThings, Commented Feb 6, 2020 at 12:44

AdminOfThings · Accepted Answer · 2020-02-06 12:50:04Z

1

$row is a reference to an object in $file2. When you update $row, $file2 is automatically updated. Therefore, you can just wait until you have made all your updates before exporting to CSV. So assuming your logic is correct for when you want to update col2 of $file2, you can do the following:

$file1 = import-csv C:\temp\csv1.csv
$file2 = import-csv C:\Temp\csv2.csv

foreach ($line in $file1) {
    foreach ($row in $file2) {
        if ($line.col1 -eq $row.col1) {
            $row.col2 = $line.col3
        }
    }
}
$file2 | Export-Csv -Path NewFile.Csv -NoType

answered Feb 6, 2020 at 12:50

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Powershell - export csv value into specific column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related