Edit Question - KnowledgeHub

Title Body

I am receiving phone numbers from a mobile device, format varies from international format or not. Scenario (ZA formats just for the example) : Registered numbers in database are always international format : +27827177982 Numbers I receive can vary e.g. +27827177982 = 27827177982 = 0827177982 - international prefix for number is +27 How do I match it to the international format even though I don't receive the international format??? Keep in mind : I can't do conversion just for 1 region. Is there a simple way of comparing mobile phone numbers for all regions? Prefixes ranges in amount of chars reference : http://en.wikipedia.org/wiki/List_of_country_calling_codes My ideas : Compare the last 9 characters of the number, this will rule out the region prefix... but does every region only have '9 characters excluding the prefix'? Loop through the database comparing the phone numbers a couple a times e.g. check for last 9 numbers - if no match - check for last 10 etc. (But can cause unwanted matches) Any help would greatly be appreciated

Tags (comma-separated) Cancel