Address Variables with PowerShell and Import-CSV foreach-loop

Question

Input file:

"Server1","lanmanserver"
"Server2","lanmanserverTest"

Program

$csvFilename = "D:\Scripts\ServerMonitorConfig.csv" 
$csv = Import-Csv $csvFilename -Header @("ServerName","ServiceName")

foreach ($line in $csv) {
    Write-Host "ServerName=$line.ServerName  ServiceName=$line.ServiceName" 
    }

What I want:

Server-Name=Server1 ServiceName=lanmanserver
Server-Name=Server2 ServiceName=lanmanserverT

What I'm getting:

ServerName=@{ServerName=Server1; ServiceName=lanmanserver}.ServerName ServiceName=@{ServerName=Server1; ServiceName=lanmanserver}.ServiceN ame ServerName=@{ServerName=Server2; ServiceName=lanmanserverTest}.ServerName ServiceName=@{ServerName=Server2; ServiceName=lanmanserverTest}. ServiceName

I really don't care if the Headers come from the first row of the CSV or not, I'm flexible there.

mjolinor · Accepted Answer · 2013-10-17 19:56:30Z

2

You usually see subexpressions or format strings used to solve that:

Subexpression:

Write-Host "ServerName=$($line.ServerName)  ServiceName=$($line.ServiceName)"

Format string:

Write-Host ('ServerName={0}   ServiceName={1}' -f $line.ServerName,$line.ServiceName)

answered Oct 17, 2013 at 19:56

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NealWalters Over a year ago

I knew it had to be simple. So what is $line.ServerName, and why does it need the extra $() around it?

NealWalters Over a year ago

This is where I'm really going with this: Write-Host "ServerName=$($line.ServerName) ServiceName=$($line.ServiceName)" $status = (get-service -Name $line.ServiceName -ComputerName $line.ServerName).Status So it looks like I only $() inside the quotes.

mjolinor Over a year ago

It's just the way the parser works on double quoted strings. To use a property of an object in an expandable string, the $object.property must be wrapped in $(), making it a subexpression.

Collectives™ on Stack Overflow

Address Variables with PowerShell and Import-CSV foreach-loop

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related