powershell - PowerShell Import-Csv 未正确读取一列的奇怪问题

Question

我创建了一个带有假用户数据的 csv 文件。此数据将用于填充测试 Active Directory。在我达到这一点之前，我必须让 Powershell 正确读取 CSV 的内容。

可以通过命令行重复该问题，如下所示：

$ADUsers = Import-Csv "C:\temp\randomNames.csv" -Header firstname, lastname, username, department, password, orgunit:

foreach ($User in $ADUsers) {
    $Username   = $User.username
    $Password   = $User.password
    $Firstname  = $User.firstname
    $Lastname   = $User.lastname
    $Department = $User.department
    $OU         = $User.orgunit

    Write-Host $Username
    Write-Host $Password
    Write-Host $Firstname
    Write-Host $Lastname
    Write-Host $Department
    Write-Host $OU
}

当脚本运行时，它会打印出除 OU 变量之外的所有内容。我不知道我在这里缺少什么。

以下是 CSV 文件的摘录：

名字、姓氏、用户名、部门、​​密码、组织单位
Karry,Dwyer,KaDwyer,Marketing,happy1,"CN=Users,OU=bob,OU=com"
Johanna,Moon,JoMoon,Facilities,hentai,"CN=Users,OU=bob,OU=com"
Beatrice,Gropper,BeGropper,Messaging,12341234,"CN=Users,OU=bob,OU=com"
Rachelle,Houng,RaHoung,Research,jackson,"CN=Users,OU=bob,OU=com"
Leland,Smit,LeSmit,Executive,brother,"CN=Users,OU=bob,OU=com"
Marlin,Pyro,MaPyro,Engineering,123654,"CN=Users,OU=bob,OU=com"
Taisha,Goto,TaGoto,DBA,222222,"CN=Users,OU=bob,OU=com"
Estelle,Holtzclaw,EsHoltzclaw,工程,游侠,"CN=Users,OU=bob,OU=com"

标签： powershellcsv