my brain hurts
Posted by:
Ron Walker
Date: August 11, 2005 11:57AM
Hello all,
This one has been teasing my brain for months, I currently have a solution, but it's well, klugey(?) a better (faster, cleaner, less klugey) solution there must be.
Problem:
matching dialied numbers (telephone) to dial code tables (country prefix and city codes) for purposes of rateing or pricing telephone calls.
Each carrier we use, supplies us with a dial code list, consisting of about 4000 possible termination destinations. for the sake of simplicity, assume we are using one lis, from a single supplier.
the problem(s)
the dialcodes are non-standard lengths, 3-9 digits (then the phone number)
the dialcodes overlap as in a country dialcode may be used for some termination numbers, and some termination numbers have combiniation of the same country code and a city code then the termination number.
CDR record shows the call was placed to south korea telepone number for example
0118234567890
Dial code table;
0118234 south korea land line
01182345 south korea mobile
011823456 another south korea mobile exchange
the dialed number would match all three of the above dial codes, and would be 'correct' but i need it to match only on the 3rd one as it is the most accurate.
any thoughts?
Subject
Written By
Posted
my brain hurts
August 11, 2005 11:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.