PowerShell脚本读取CSV文件的ComputerName与UserName列问题

Hey there! Let's walk through refining your PowerShell script for reading that CSV file. First, let's address a couple of potential pitfalls in your current approach and share a cleaner, more efficient way to handle this.

首先，注意CSV格式的空格问题 #

Looking at your CSV example:

ComputerName | Username
computer01 | user1
computer02 | user2

The spaces around the | delimiter mean that when you import the CSV, your column names might end up with extra whitespace (like ComputerName and Username instead of clean ComputerName and Username). This will cause issues when you try to access $_.ComputerName later—so we need to clean that up first.

优化后的脚本 #

Instead of using += to build arrays (which is inefficient, since it creates a new array every time), we can leverage PowerShell's object-oriented nature to handle this more smoothly:

# 读取CSV并清理列名和值中的空格
$csvData = Import-Csv -Path "C:\test\script\Computername_username_test.csv" -Delimiter "|" | ForEach-Object {
    # 创建一个清理后的自定义对象
    $cleanedItem = [PSCustomObject]@{
        ComputerName = $_.PSObject.Properties.Name.Where({$_ -match 'ComputerName'}, 'First').Value.Trim()
        Username = $_.PSObject.Properties.Name.Where({$_ -match 'Username'}, 'First').Value.Trim()
    }
    $cleanedItem
}

# 如果确实需要单独的数组（建议优先使用上面的$csvData对象）
$computerNames = $csvData.ComputerName
$userNames = $csvData.Username

# 创建目标目录（添加-Force避免目录已存在时报错）
$destination = New-Item -ItemType Directory -Path "C:\test\your-destination-path" -Force

为什么这样更好？ #

• 效率更高: 直接从导入的CSV对象中提取属性，避免了+=导致的频繁数组重建（这在数据量大时差异很明显）
• 更健壮: 自动处理列名中的空格问题，不会因为CSV格式的小瑕疵导致脚本失败
• 更灵活: 保留了完整的对象结构（$csvData），后续遍历或操作每一行的计算机/用户对会更方便，比如：

  foreach ($entry in $csvData) {
      Write-Host "Processing computer: $($entry.ComputerName) for user: $($entry.Username)"
      # 在这里添加你的业务逻辑，比如远程操作、文件处理等
  }
  

简化版（如果CSV格式严格无空格） #

如果你的CSV实际没有空格（比如列名是ComputerName|Username，值是computer01|user1），可以简化成：

$csvData = Import-Csv -Path "C:\test\script\Computername_username_test.csv" -Delimiter "|"
$computerNames = $csvData.ComputerName
$userNames = $csvData.Username
$destination = New-Item -ItemType Directory -Path "C:\test\your-destination-path" -Force

内容的提问来源于stack exchange，提问作者MarkyMark