YXJK/kxc

$ awk -F',' '/vDS-cluster-YW/{ print "Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name",$1,"-NumPorts 8 -VlanId",$5 }' < dvPort-kxc.csv | sed 's#.X#.N#g;s#.Y#.N#g;s#.x#.N#g;s#.NW#-YW#g' | grep -v DVUp

Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.129.0.N -NumPorts 8 -VlanId 100
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.129.16.N -NumPorts 8 -VlanId 116
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.129.80.N -NumPorts 8 -VlanId 180
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.130.0.N -NumPorts 8 -VlanId 200
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.130.16.N -NumPorts 8 -VlanId 216
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.130.80.N -NumPorts 8 -VlanId 280
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.0.N -NumPorts 8 -VlanId 300
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.1.N -NumPorts 8 -VlanId 301
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.16.N -NumPorts 8 -VlanId 316
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.17.N -NumPorts 8 -VlanId 317
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.18.N -NumPorts 8 -VlanId 318
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.2.N -NumPorts 8 -VlanId 302
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.80.N -NumPorts 8 -VlanId 380
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.81.N -NumPorts 8 -VlanId 381
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.131.82.N -NumPorts 8 -VlanId 382
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.132.0.N -NumPorts 8 -VlanId 400
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.132.1.N -NumPorts 8 -VlanId 401
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.132.16.N -NumPorts 8 -VlanId 416
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.132.17.N -NumPorts 8 -VlanId 417
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.132.80.N -NumPorts 8 -VlanId 480
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.133.0.N -NumPorts 8 -VlanId 500
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.133.16.N -NumPorts 8 -VlanId 516
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.133.80.N -NumPorts 8 -VlanId 580
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.134.0.N -NumPorts 8 -VlanId 600
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.134.16.N -NumPorts 8 -VlanId 616
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.134.80.N -NumPorts 8 -VlanId 680
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.135.0.N -NumPorts 8 -VlanId 700
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.135.16.N -NumPorts 8 -VlanId 716
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.135.80.N -NumPorts 8 -VlanId 780
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.136.0.N -NumPorts 8 -VlanId 800
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.136.16.N -NumPorts 8 -VlanId 816
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.136.80.N -NumPorts 8 -VlanId 880
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.137.0.N -NumPorts 8 -VlanId 900
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.137.16.N -NumPorts 8 -VlanId 916
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.137.80.N -NumPorts 8 -VlanId 980
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.138.0.N -NumPorts 8 -VlanId 1000
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.138.16.N -NumPorts 8 -VlanId 1016
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.138.80.N -NumPorts 8 -VlanId 1080
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.139.0.N -NumPorts 8 -VlanId 1100
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.139.1.N -NumPorts 8 -VlanId 1101
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.139.16.N -NumPorts 8 -VlanId 1116
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.139.80.N -NumPorts 8 -VlanId 1180
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.140.1.N -NumPorts 8 -VlanId 3201
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.140.10.N -NumPorts 8 -VlanId 3210
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.140.12.N -NumPorts 8 -VlanId 3212
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.141.0.N -NumPorts 8 -VlanId 1300
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.141.16.N -NumPorts 8 -VlanId 1316
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.141.80.N -NumPorts 8 -VlanId 1380
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.142.0.N -NumPorts 8 -VlanId 1400
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.142.16.N -NumPorts 8 -VlanId 1416
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.142.80.N -NumPorts 8 -VlanId 1480
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.143.0.N -NumPorts 8 -VlanId 1500
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.143.16.N -NumPorts 8 -VlanId 1516
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.143.80.N -NumPorts 8 -VlanId 1580
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.145.16.N -NumPorts 8 -VlanId 1716
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.147.16.N -NumPorts 8 -VlanId 1816
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.148.0.N -NumPorts 8 -VlanId 2000
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.148.16.N -NumPorts 8 -VlanId 2016
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.148.80.N -NumPorts 8 -VlanId 2080
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.158.0.N -NumPorts 8 -VlanId 3000
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 100.168.32.N -NumPorts 8 -VlanId 3400
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name 3499-test -NumPorts 8 -VlanId 3499
Get-VDSwitch -Name vDS-cluster02-YW | New-VDPortgroup -Name oracle_test -NumPorts 8 -VlanId 0