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.
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!