How to extract country name by phone number

[Anonymous]

Hi,

Is there any way we could extract and identify the Country Name with the help of there phone number or dialing code?

I have extracted the dialing code from the phone number but unable to get the Country Name.

Any Help would be appreciated.

Thanks.

[Yousef_Amarneh]

I think you can find country codes database online. I already downloaded one.

[kaushiknsolanki]

Hi,

     You will need the ISD mapping table which will tell you which ISD code is for which country, then you can link that with your extracted code field.

Regards,

Kaushik Solanki

[ashfaq_haseeb · Accepted solution]

Hi,

Have a look at attached application.

Regards

ASHFAQ

[VishalWaghole]

Hi,

Just insert this code in you script

if(Match('00'&Left(Phoneno,2),0091),'India','Pakistan') as Country

and also please find attached Qvw.

-- Regards,

Vishal Waghole

[Anonymous]

Thanks for your reply Yousef.

But then i have to incorporate it into the script as well and i can not as the data model is already a bit cluttered, is there any other work around?

Thanks.

[#7]

you need to load a dialing code - country mapping table firstly from internet, it's easy to obtain~

[Anonymous]

Thanks all for the help, it worked.

[Anonymous]

Sorry for keeping this thread alive, but there is still a problem.

As we have extracted the dialing code from phone number by using the Left(phoneno,2) it will only extract the first two digits but most of the countries have 1 and 3 numbers as there dialing code.

What would be the solution if there is 1, 2 or 3 numbers in the country code.

Please consider we do not have any separator in the phone number or else it would have been done by the help of Subfield.

Thanks.

[ashfaq_haseeb]

Hi

Mobile number will be fixed length

You may use that to slice code number.

Regards

ASHFAQ