StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I came up with the following example.</p> <p>A method to convert IP Addresses to numbers for this purpose is easily found so I included the link inside the method I derived it from.</p> <p>I am using Regular Expressions to test whether the input data matches a pattern, feel free to omit or alter as you need. (For example, Unix style MAC addresses use colons (:) instead of hyphens (-).)</p> <p>To convert MAC addresses, I am just omitting the delimiter and parsing the entire string as a long int.</p> <p>In my example, I am showing the numbers to which several example IP and MAC addresses convert, so you can define the upper and lower bounds and test various combinations.</p> <pre><code>using System.Globalization; using System.Text.RegularExpressions; string IP_UpperLimit = "192.168.1.255"; string IP_LowerLimit = "192.168.1.1"; string Mac_UpperLimit = "99-EE-EE-EE-EE-EE"; string Mac_LowerLimit = "00-00-00-00-00-00"; string IP_WithinLimit = "192.168.1.100"; string IP_OutOfBounds = "10.10.1.1"; string Mac_WithinLimit = "00-AA-11-BB-22-CC"; string Mac_OutOfBounds = "AA-11-22-33-44-55"; Console.WriteLine("IP Addresses:"); Console.WriteLine("Upper Limit: " + ConvertIP(IP_UpperLimit)); Console.WriteLine("Lower Limit: " + ConvertIP(IP_LowerLimit)); Console.WriteLine("IP_WithinLimit: " + ConvertIP(IP_WithinLimit)); Console.WriteLine("IP_OutOfBounds: " + ConvertIP(IP_OutOfBounds)); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("Mac Addresses:"); Console.WriteLine("Upper Limit: " + ConvertMac(Mac_UpperLimit)); Console.WriteLine("Lower Limit: " + ConvertMac(Mac_LowerLimit)); Console.WriteLine("Mac_WithinLimit: " + ConvertMac(Mac_WithinLimit)); Console.WriteLine("Mac_OutOfBounds: " + ConvertMac(Mac_OutOfBounds)); long ConvertIP(string IP) { // http://www.justin-cook.com/wp/2006/11/28/convert-an-ip-address-to-ip-number-with-php-asp-c-and-vbnet/ Regex r = new Regex(@"\b(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b"); if (!r.Match(IP).Success) return 0L; string[] IPSplit = IP.Split('.'); long IPNum = 0L; for (int i = IPSplit.Length - 1; i >= 0; i--) IPNum += ((Int64.Parse(IPSplit[i]) % 256) * (long)Math.Pow(256, (3 - i))); return IPNum; } long ConvertMac(string Mac) { Regex r = new Regex(@"^[0-9A-F]{2}-[0-9A-F]{2}-[0-9A-F]{2}-[0-9A-F]{2}-[0-9A-F]{2}-[0-9A-F]{2}$"); if (!r.Match(Mac).Success) return 0L; return Int64.Parse(Mac.Replace("-", String.Empty), NumberStyles.HexNumber); } </code></pre> <p>So, to make use of these methods, you just perform some comparisons on the converted values:</p> <pre><code>bool IPIsGood = ConvertIP(IP_UpperLimit) >= ConvertIP(IP_Test) && ConvertIP(IP_LowerLimit) <= ConvertIP(IP_Test); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload