in reply to Re: IP Address consolidation
in thread IP Address consolidation
My apologies ..
The clarifications are thus :
1. IP Address file has the range of IP Addresses held by the name that appears in the same line.
2. I need to join adjacent ranges belonging to the same name; thus reducing the number of lines in the file.
3. In the first example, Line 2 follows Line 1 because 202.3.0.0 is the next IP Address after 202.2.255.255.
Similarly, if the "From" of one line is the next IP of the "TO" of the previous line, and the name is the same, the record needs to be replaced by the "From" of the first line, the "To" of the following line, and the common "Name"
Hope this helps