I have a CSV with 4 Columns. I am trying to copy values from the costs column to the corpcosts columns based on values from the department number column. Basically, any cost with department number starting with 8* to be moved or copied to the corpcost column.

For reference:

Original:

Expectation:

I have tried using a foreach loop, but I must admit I am fairly new to PowerShell and learning as I go. The code I have tried thus far is as follows:

$corpcosts= foreach($corpcost in $CSVImport.corpcosts){
        if($CSVImport.DepartmentNumber -eq "8*"){
            $CSVImport.DepartmentNumber   $CSVImport.Costs 
        }
    }
           
$CSVImport|Select-Object *, @{N= 'CorpCosts'; E={$corpcosts[$_.CorpCosts]}} |Export-Csv "$Env:temp/$OutputFile" -NoTypeInformation 

CodePudding user response：

The Expression only needs a few changes to add an if statement to check for departments starting with the number 8, and if true, fill with the Costs column into the new CorpCosts column.

$CSVImport = Import-Csv Costs.csv
$CSVImport|Select-Object *, @{N= 'CorpCosts'; E={if($_.DepartmentNumber -like '8*'){$_.Costs}}} | Export-Csv "$Env:temp/$OutputFile" -NoTypeInformation 

CodePudding user response：

You can do it with just one calculated property, for the comparison you could either use .StartsWith or a Matching Operator of your choice (either -like '8*' or -match '^8'), not that equality operators are not aware of wildcard characters (*).

Import-Csv path\to\source.csv |
    Select-Object *, @{N='CorpCosts';E={ if($_.DepartmentNumber.StartsWith('8')) { $_.Costs } }} |
    Export-Csv path\to\output.csv -NoTypeInformation