Search and Replace in .csv file

by Oct 14, 2011

I have two .csv files, one (inv_orig)contains a master list of computernames, status etc.  The other contains updated information that needs to be added to the master sheet.  If the computername from the updated sheet exists in the mastersheet, I need to update the status field on the master with "migrated" text.

Im sure my syntax is incorrect but cant seem to get this to work properly.  Any help is greatly appreciated

$csv = import-csv c:itaminv_blank.csv |select-object "old machine name"
$csv_orig = import-csv c:itaminv_orig.csv

###Need help here


$csv_orig |-replace $currentiem.status,"Migrated" |where-object -eq $csv