如何让这个foreach-object正确运行？

Question

我正在尝试读取包含CompanyName,UserCount列的.csv并编辑.rdp文件。输出应该创建多个.rdp文件，同时更改.rdp本身和名称中的3行。

到目前为止，我有这样的想法：

$testRDP = (Get-Content C:\Users\Administrator.PT\Desktop\Test.rdp)
$remoteAPP = @()
$rdpName = @()
$companyNames=Import-Csv C:\Users\Administrator.PT\Desktop\CompanyNames.csv
foreach ($name in $companyNames) {
    for ($i = 1; $i -le $name.UserCount; $i++) {
        $remoteAPP = "RemoteApp" + $name.CompanyName + ".address.com"
        $rdpName = $name.CompanyName + $i + ".rdp"
        $aliasRDP = $name.CompanyName + $i
        ForEach-Object {$testRDP -replace 'remoteapp.address.com', $remoteAPP}
        ForEach-Object {$testRDP -replace 'user', $aliasRDP} | 
Out-File C:\Users\Administrator.PT\Desktop\$rdpName
        }
}

运行此命令会将'user'替换为$aliasRDP，但'remoteapp.address.com'保持不变。我猜我的渠道是错的。如果我能澄清一些更好的东西，请告诉我。

谢谢。

Answer 1

事实上，您根本不需要ForEach-Object：

$testRDP = (Get-Content C:\Users\Administrator.PT\Desktop\Test.rdp)
$remoteAPP = @()
$rdpName = @()
$companyNames=Import-Csv C:\Users\Administrator.PT\Desktop\CompanyNames.csv
foreach ($name in $companyNames) {
    for ($i = 1; $i -le $name.UserCount; $i++) {
        $remoteAPP = "RemoteApp" + $name.CompanyName + ".address.com"
        $rdpName = $name.CompanyName + $i + ".rdp"
        $aliasRDP = $name.CompanyName + $i
        $testRDP -replace 'remoteapp.address.com', $remoteAPP -replace 'user', $aliasRDP | 
Out-File C:\Users\Administrator.PT\Desktop\$rdpName
        }
}

下面是使用正则表达式匹配和替换字符串的版本。它更安全，因为原始脚本将替换文件中任何位置的匹配项，这可能是致命的。

$testRDP = (Get-Content -Path 'C:\Users\Administrator.PT\Desktop\Test.rdp')
$companyNames = Import-Csv -Path 'C:\Users\Administrator.PT\Desktop\CompanyNames.csv'
foreach ($name in $companyNames) {
    for ($i = 1; $i -le $name.UserCount; $i++) {
            $remoteAPP = 'RemoteApp' + $name.CompanyName + '.address.com'
            $rdpName = $name.CompanyName + $i + '.rdp'
            $aliasRDP = $name.CompanyName + $i
            $testRDP -replace '^(full address:s:).*$', "`$1$remoteAPP" -replace '^(username:s:).*$', "`$1$aliasRDP" |
                Out-File -FilePath "C:\Users\Administrator.PT\Desktop\$rdpName"
    }
}