Calling dynamic variable in PowerShell

by

First of all, your New-Variable invocation doesn’t do what you think it does, as you’d pipe the output of New-Variable to Where-Object instead of using the value of $Transactions | Where ... as value for the variable. You need parentheses for that to work:

New-Variable -Name "Transactions_$Year" -Value ($Transactions | Where {$_.Date -like "*.$Year" })

If you absolutely have to use this approach, then you can get the variables again via Get-Variable:

Get-Variable Transactions_$Year | % Value

However, multiple variables with magic names is a rather poor way of solving this. You probably rather want a map:

$TransactionsPerYear = @{}
$Years | ForEach-Object {
  $TransactionsPerYear[$_] = $Transactions | Where Date -like "*.$_"
}

And you can get all transactions for 2015 with $TransactionsPerYear[2015].

Another way is Group-Object which doesn’t even require a list of possible years to begin with, but groups a number of objects by some property or expression result:

$TransactionsPerYear = $Transactions | Group-Object { [int]($_.Date -replace '.*\.') }

(This is a guess on how it could work. It seems like your date string contains something up to a period, after which there is the year and nothing else, so perhaps something like dd.MM.yyyy date format.

More Related Contents:

  1. If Statement Against Dynamic Variable [duplicate]
  2. Create an incrementing variable from 2 variables in PowerShell
  3. Using a Variable (PowerShell) inside of a command
  4. How do I pass variables with the Invoke-Command cmdlet?
  5. Why won’t Variable update?
  6. Expanding variables in file contents
  7. Get-Aduser -Filter will not accept a variable
  8. Powershell executable isn’t outputting to STDOUT
  9. How to escape special characters in PowerShell?
  10. Read file line by line in PowerShell
  11. how do I loop through a line from a csv file in powershell
  12. Access PSObject property indirectly with variable
  13. How to remove all quotations mark in the csv file using powershell script?
  14. Is there a way to set a variable up to place output to stdout or null?
  15. Executing an EXE file using a PowerShell script
  16. How to properly -filter multiple strings in a PowerShell copy script
  17. Powershell pass variable to start-job
  18. Write-Host vs Write-Information in PowerShell 5
  19. Why does “Get-ChildItem -File | Get-FileHash” work?
  20. Powershell Using Start-Process in PSSession to Open Notepad
  21. Powershell Get-ChildItem most recent file in directory
  22. Powershell – Reboot and Continue Script
  23. Hashtables and key order
  24. Executing powershell command directly in jenkins pipeline
  25. Should $null be on the left side of the equality comparison? (-eq with arrays)
  26. How can I redirect stdout and stderr without polluting PowerShell error output
  27. Check if a file exists or not in Windows PowerShell?
  28. Variable scoping in PowerShell
  29. Read a Csv file with powershell and capture corresponding data
  30. PS Script is exporting an empty CSVs

Leave a Comment