Country Code Lookup

[Bajjee]

Hi,

We get a very detailed Call Data Records(CDR) for all telephone calls made by our employees. CDR typically contains the called number, duration in seconds and cost. What is missing it the city name and country name for the called number.

For e.g. a typical CDR log would be
Called # duration(secs) Cost
442075000000 40 0.02

From looking at this number, the country code is UK - 44 and the city code is 20 which is London.

I have a spreadsheet that contains Country code and city code for all major cities in the world.

Is it possible to create a lookup function, that would take the 'Called #' from the CDR and lookup the data in the CountryCity code spreadsheet and give me the called City and Contry name.

Please note the contry code is not always first two digits, it could more than two digits and same is with the city code.

Thanks for your help,
-Bajjee

 

[chrissyclark]

<table style="border-collapse: collapse; width: 48pt;" width="64" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"><tr style="height: 14.4pt;" height="19"> <td style="height: 14.4pt; width: 48pt;" width="64" height="19">I found a great site for <table style="border-collapse: collapse; width: 231pt;" width="308" border="0" cellpadding="0" cellspacing="0"><col style="width: 231pt;" width="308"><tr style="height: 14.4pt;" height="19"> <td class="xl66" style="height: 14.4pt; width: 231pt;" width="308" height="19">area codes</td> </tr></table> data and other useful information.</td> </tr></table>