First time post...
I have a csv file that gets sent to me every month from our network folks. see below.
The third column I currently put in manually however it is a pain since we have 1700 subnets to deal with. Can anyone help me populate the third column using the CIRD syntax. Even better, my ultimate solution would have the third column look like
eg: 172.25.103.64/26
172.25.11.0/24
etc...
The reason for the proper syntax is that I take this list and import it into my network scanning tool.
monthly csv example
172.25.103.64 255.255.255.192 /26
172.25.104.0 255.255.255.192 /26
172.25.104.128 255.255.255.128 /25
172.25.104.64 255.255.255.192 /26
172.25.105.0 255.255.255.192 /26
172.25.105.128 255.255.255.128 /25
172.25.105.64 255.255.255.192 /26
172.25.11.0 255.255.255.0 /24
172.25.12.0 255.255.255.0 /24
172.25.13.0 255.255.255.0 /24
172.25.14.0 255.255.255.0 /24
172.25.143.0 255.255.255.128 /25
172.25.148.0 255.255.255.0 /24
172.25.15.0 255.255.255.0 /24
172.25.150.0 255.255.255.192 /26
172.25.150.128 255.255.255.192 /26
172.25.150.192 255.255.255.192 /26
172.25.150.64 255.255.255.192 /26
172.25.151.0 255.255.255.192 /26
172.25.151.128 255.255.255.192 /26
Bookmarks