Re: summarization of list

[gman]

Thanks to all that have responed.
Here is some more helpfull information that I probably
should have stated from the start.
The list is given to me in an excel spread sheet. Useing Spreadsheet::ParseExcel::Simple I pull out the
data and put it in a hash of hash of hash.

$VAR1 = 'rg0005';
$VAR2 = {
          '718' => {
                     '559' => 'rg0005',
                     '554' => 'rg0005',
                     '942' => 'rg0005',

the inner 3 digits is what I have to summarize on.
So the list is large, but I think I have a starting point.
Sorting it correctly seems to be the key.
Any more sugestions are welcome!
If I get it I will post the code.
Thanks again

[QM]

You still haven't explained what you're trying to do. It's only because some of the other replies belong to near psychics that you have something to work with.

[gman]

Ok, let me see if I can explain what I am trying to do.
I am taking in a list that has a format of:
npa,nxx,trunkname
Think phone numbers in north American dial plan.
the system I am feeding can take the whole 6 digits, but
will match on lesser digits. So Instead of always
inputting all 6 digits and pointing that to a trunk group.
I can say 33021 points to trunk 1000
And 330215 points to trunk 10002
Meaning that all other nxx combinations except 330215
will match trunk 1000.
Hope this make sense.