R
Rob
I'm trying to build a filter list for spam blocking. I have foreight IP
lists from ARIN.net. I have broken down the list into 8 columns: StartA,
StartB, StartC, StartD, EndA, EndB, EndC and EndD to reflect the starting
and ending IP address structure of the block I want to filter.
StartA StartB StartC StartD EndA EndB EndC EndD58 2 0 0 58 2 255 25558 3 0 058 3 127 25558 3 128 0 58 3 255 25558 4 0 0 58 5 255 25558 7 0 0 58 7 127 255I'd like to use some sort of IF statement in the next column to determine
how I can consolidate the sequences. Obviously if I'm going to block
58.2.0.0-58.2.255.255 and then 58.3.0.0-58.3.127.255, I might as well just
block 58.2.0.0-58.3.127.255, etc.
Since this XLS file is about 12,000 rows long, I don't want to go through it
manually, and not all the ranges will be contiguous, how can I build one or
more IF statements (or whatever will help) so that I can figure out the best
low and high end of contiguous ranges of IPs?
Tremendous Thanks.
lists from ARIN.net. I have broken down the list into 8 columns: StartA,
StartB, StartC, StartD, EndA, EndB, EndC and EndD to reflect the starting
and ending IP address structure of the block I want to filter.
StartA StartB StartC StartD EndA EndB EndC EndD58 2 0 0 58 2 255 25558 3 0 058 3 127 25558 3 128 0 58 3 255 25558 4 0 0 58 5 255 25558 7 0 0 58 7 127 255I'd like to use some sort of IF statement in the next column to determine
how I can consolidate the sequences. Obviously if I'm going to block
58.2.0.0-58.2.255.255 and then 58.3.0.0-58.3.127.255, I might as well just
block 58.2.0.0-58.3.127.255, etc.
Since this XLS file is about 12,000 rows long, I don't want to go through it
manually, and not all the ranges will be contiguous, how can I build one or
more IF statements (or whatever will help) so that I can figure out the best
low and high end of contiguous ranges of IPs?
Tremendous Thanks.