csv - 使用CSV和PowerSHell进行输出格式化

Question

CSV格式如下:

Username,Password
jsmith,Password!
jdoe,Password!
bob,Password!

PowerShell脚本:

$users = Import-CSV -Path "C:\path\users.csv"

foreach ($user in $users) {
     Write-Host "Username: $user.Username"
     Write-Host "Password: $user.Password"
}

输出:

Username: @{Username=jsmith; Password=Password!}.Username
Password: @{Username=jsmith; Password=Password!}.Password
Username: @{Username=jdoe; Password=Password!}.Username
Password: @{Username=jdoe; Password=Password!}.Password
Username: @{Username=bob; Password=Password!}.Username
Password: @{Username=jsmith; Password=Password!}.Password

这是较大脚本的一部分，我需要能够使用 $user.XXXX格式进行引用。我读过的文章显示这应该可行，但是我显然在格式化方面缺少一些愚蠢的东西。我究竟做错了什么？

Answer 1

尝试进行插值时，需要将对象属性“转义”到变量中。以下将代替:

foreach ($user in $users) {
     Write-Host "Username: $($user.Username)"
     Write-Host "Password: $($user.Password)"
}

另外，您可以使用格式字符串运算符:

foreach ($user in $users) {
     "Username: {0}" -f $user.Username
     "Password: {0}" -f $user.Password
}