AnsweredAssumed Answered

Global Phone Number Formatting

Question asked by user30198 on Jan 31, 2019
Latest reply on Feb 11, 2019 by jfletch


Hi All - I have a new customer in France who has customers around the world and wishes to store their contact information, such as a phone number. It would be nice to be able to determine their country and then assign the appropriate formatting of the phone number as result.

 

Has anyone handled this situation before? or is anyone aware of a good way to handle this - is there an example solution or article somewhere that discusses a good technique for handling different phone number structures of the world.

 

I already use a let statement and such for handling Australian numbers etc however this is global and a search found there are many different ways phone numbers are handled around the world.

 

List of mobile telephone prefixes by country - Wikipedia

 

It makes me wonder if the best approach is for countryCode, areaCode and phoneNumber to be in seperate fields and then keeping it simple spacing out data in the phone number field by 2-3 characters.

 

I look forward to your insights.

 

Enjoy your weekend!

 

Troy

Outcomes