in reply to summarization of list

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

Replies are listed 'Best First'.
Re^2: summarization of list
by QM (Parson) on Mar 15, 2006 at 17:44 UTC
    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.

    -QM
    --
    Quantum Mechanics: The dreams stuff is made of

      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.