Powershell loop through two arrays and add content to file

Question

I have to add text from one file to the end of another file, but the contents of one file is significantly shorter than the other, so I want to keep looping through the shorter file until the longer file is complete. I generate the intial file (scopeout.txt) with the following code

$a = "NETSH Dhcp Server 192.168.10.1 Scope "
$b = " set optionvalue 6 IPADDRESS "
$Scopelist = Get-Content C:\ListOfScopes.txt

foreach ($i in $ListOfScopes)

{
$a + $i + $b >> C:\TestArea\scopeout.txt
}

I then have a file called newdns.txt that contains 4 entries (192.168.0.10, 192.168.0.11, 192.168.0.12, 192.168.0.13). I want to read each line of scopeout.txt, add 1 entry from newdns.txt, then move onto the next line in each file. I want to repeat this process until scopeout.txt is finished, so the final file will look similar to the following:

NETSH Dhcp Server 192.168.10.1 Scope 192.168.50.1 set optionvalue 6 IPADDRESS 192.168.0.10
NETSH Dhcp Server 192.168.10.1 Scope 192.168.51.0 set optionvalue 6 IPADDRESS 192.168.0.11
NETSH Dhcp Server 192.168.10.1 Scope 192.168.52.0 set optionvalue 6 IPADDRESS 192.168.0.12
NETSH Dhcp Server 192.168.10.1 Scope 192.168.53.0 set optionvalue 6 IPADDRESS 192.168.0.13
NETSH Dhcp Server 192.168.10.1 Scope 192.168.54.0 set optionvalue 6 IPADDRESS 192.168.0.10
NETSH Dhcp Server 192.168.10.1 Scope 192.168.55.0 set optionvalue 6 IPADDRESS 192.168.0.11
NETSH Dhcp Server 192.168.10.1 Scope 192.168.56.0 set optionvalue 6 IPADDRESS 192.168.0.12
NETSH Dhcp Server 192.168.10.1 Scope 192.168.57.0 set optionvalue 6 IPADDRESS 192.168.0.13
NETSH Dhcp Server 192.168.10.1 Scope 192.168.58.0 set optionvalue 6 IPADDRESS 192.168.0.10
NETSH Dhcp Server 192.168.10.1 scope 192.168.59.0 set optionvalue 6 IPADDRESS 192.168.0.11

I have experimented with using a foreach statement, but I am unsure how to combine 2 foreach statements and also how to keep looping through the newdns.txt until scopeout.txt is complete.

Shay Levy · Accepted Answer · 2012-11-27 18:51:13Z

2

Try this:

$c = 0
$ip = Get-Content C:\newdns.txt

Get-Content C:\ListOfScopes.txt | Foreach-Object{
    if ($c -gt 3) {$c=0} 
    "NETSH Dhcp Server 192.168.10.1 Scope $_ set optionvalue 6 IPADDRESS $($ip[$c])"
    $c++
}

answered Nov 27, 2012 at 18:51

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stereostar Over a year ago

That is exactly what I needed, worked perfectly. Thank you very much for your help

Collectives™ on Stack Overflow

Powershell loop through two arrays and add content to file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related