Sedang Disiapkan

Convert IP range to network/nnn CIDR specification

I have a list of IP ranges in this format:

112.0.0.0 / [url removed, login to view]

e.g. start / stop

and I need it converted into this format:

112.0.0.0/8

Must be able to handle all cases, not just simple ones. e.g.

11.0.0.0/ [url removed, login to view]

112.255.0.0/ [url removed, login to view]

and so on.

To be delivered as an excel vba macro that takes two string parameters and returns one.

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: excel cidr, cidr excel, convert cidr, convert range, cidr specification, convert range cidr, convert cidr range excel, excel convert cidr, cidr convert, range cidr, convert cidr excel, convert cidr range, networknnn cidr specification, convert cidr format, excel convert range cidr, excel cidr range, convert address cidr, range convert, convert network range, convert ranges cidr, calculate cidr range, convert range network, range specification, range cidr excel, convert cidr ranges

Tentang Majikan:
( 34 ulasan ) Cheung Chau, Hong Kong

ID Projek: #305186

Dianugerahkan kepada:

arun88m

Hi, I am very glad to find this project. Its a very easy one and I will be able to finish within three-five hours of the assignment of the job. I am a student of IIT Kharagpu (check http://ed.sjtu.edu.cn/rank/200 Lagi

$50 USD dalam sehari
(2 Ulasan)
1.4

5 pekerja bebas membida secara purata $40 untuk pekerjaan ini

proffcomp

In order to perform this function, I would convert both set of four octets to binary numbers. To calculate the first address, I would AND the two sets of octets. To calculate the second address, I would AND the first Lagi

$45 USD dalam sehari
(0 Ulasan)
0.0
Raghunat

Hi, I'm new to freelancel.I'm having 2y of exp in vba.I can complete it with in a day. If you are intrested mail me on [removed] with your contact details.

$30 USD dalam sehari
(0 Ulasan)
0.0
hgtyuj

Hi, I am very interested in this development. Please check PM. Best Regards,

$44 USD dalam sehari
(0 Ulasan)
0.0
jayc428

It is a simple enough excel function, would only take 30-45 minutes to finish.

$30 USD dalam 0 hari
(0 Ulasan)
0.0