Just a quick share as I needed this for something, this function will replace values in a CSV file. It takes the desired column(s) and value(s) to search for and a new value and desired target column as required parameters.<\/p>\n\n\n\n
\nfunction update-csvColumn{\n Param(\n [Parameter(Mandatory=$true)]$csvContents, #input original CSV file contents here (use import-csv first)\n [Parameter(Mandatory=$true)][Array]$searchForColumns, #names of the columns you want to base your search on\n [Parameter(Mandatory=$true)][Array]$searchForValues, #replace rows in $searchForColumn that match these values (in same order!)\n [Parameter(Mandatory=$true)]$replaceColumn, #set this column to what you specified in $newValue\n [Parameter(Mandatory=$true)]$newValue #the new value you wish to set $searchForColumn or $replaceColumn to\n )\n if($searchForColumns.Count -ne $searchForValues.Count) {Throw "You must supply an equal number of columns and values to match on"}\n for($i = 0; $i -lt $csvContents.Count; $i++){\n $replace = $True\n for($c = 0; $c -lt $searchForColumns.Count; $c++){\n if($csvContents[$i].$($searchForColumns[$c]) -ne $searchForValues[$c]){\n $replace = $False\n }\n }\n if($replace){\n $csvContents[$i].$replaceColumn = $newValue\n }\n }\n return $csvContents\n}\n<\/pre><\/p>\n","protected":false},"excerpt":{"rendered":"Just a quick share as I needed this for something, this function will replace values in a CSV file. It takes the desired column(s) and value(s) to search for and a new value and desired target column as required parameters. function update-csvColumn{ Param( [Parameter(Mandatory=$true)]$csvContents, #input original CSV file contents here (use import-csv first) [Parameter(Mandatory=$true)][Array]$searchForColumns, #names … Continue reading Helper function to replace data in a CSV file<\/span>