powershell csv循环PSCustomObject

Question

​

​

我正在尝试迭代VM名称并将它们存储在PSCustomObject中，并在输出中按顺序分配一个子网，如下所示: VM1 Subnet1 VM2 Subnet2 VM3 Subnet3 VM4 Subnet1 VM5 Subnet2 How to output。

$csv = import-csv C:\ps\sample.csv
$myobject = foreach ($line in $csv){
    if ($line.count -gt 0) {
        for($i = 0; $i -lt $line.count; $i++){
            $count = $i + 1
                [pscustomobject]@{
                VMName = $line.vmname+$count
                Subnet = $line.subnet -split ',' | Get-Random
                Sku    = $line.sku
                os     = $line.os
                }
            }
        }
    }
$myobject

谢谢！

Answer 1

下面的代码完成以下工作：

$csv = import-csv C:\ps\sample.csv -Delimiter ';'
$myobject = foreach ($line in $csv){
    if ($line.count -gt 0) {
        for($i = 0; $i -lt $line.count; $i++){
            $ar_sub = $line.subnet -split ','
            $l_sub = $ar_sub.count

                [pscustomobject]@{
                VMName = $line.vmname+$count
                Subnet = $ar_sub[$i % $l_sub]
                Sku    = $line.sku
                os     = $line.os
                }
            }
        }
    }
$myobject

结果：

VMName Subnet  Sku      os    
------ ------  ---      --    
appvm1 subnet1 t2.mciro centos
appvm2 subnet2 t2.mciro centos
appvm3 subnet3 t2.mciro centos
appvm4 subnet1 t2.mciro centos
appvm5 subnet2 t2.mciro centos
dbvm1  subnet4 t3.micro centos
dbvm2  subnet5 t3.micro centos
dbvm3  subnet6 t3.micro centos
dbvm4  subnet4 t3.micro centos