Set Variable assigning Import-csv value-CodePudding

I am trying to assign import-csv value to a set variable under a loop so i can work with the csv file on variable $var1, $var2,$var3 like..

$i = 1
{
$result = Export-Csv -Path ".\$varname.csv" -NoTypeInformation 
New-Variable -Name "var$i" -Value "import-csv -Path .\$varname.csv"
Get-Variable -Name "var$i" -ValueOnly
$i  

}

CodePudding user response：

Your question is missing the actual problem you need help with or what is failing.
I see you're using Export-Csv, I would assume you meant to use Import-Csv.

If you want to store the content of a CSV and set that content to dynamically created variables, this is how you can do it:

$numberOfvariables = 5
$csv = Import-Csv path/to/csv.csv

0..$numberOfvariables | ForEach-Object {
    Set-Variable -Name var$_ -Value $csv
}

Note that, I'm using Set-Variable instead of New-Variable, both serve the same purpose in this example however if you re-run the script without removing the variables you would get the exception A variable with name 'var' already exists. using New-Variable unless you use the -Force switch.