Cecil
19+ years progress programming and still learning.
I need to create a function which will split up a mobile phone number into three parts 'International Dial Code', 'Area Code' and ''Mobile Number'
Current;y on the database person contact numbers are stored in a single field and variaty of formats.
i.e.
+64212345645 or 0064212345645 or 0212345645. or even +64 (0) 21 2345 645
TestCase:
INPUT "+64212345645" would retrun "64", "021", "2345645"
INPUT "0064212345645 " would retrun "64", "021", "2345645"
INPUT "0212345645" would retrun "64", "021", "2345645"
Has anybody done this?
Current;y on the database person contact numbers are stored in a single field and variaty of formats.
i.e.
+64212345645 or 0064212345645 or 0212345645. or even +64 (0) 21 2345 645
TestCase:
INPUT "+64212345645" would retrun "64", "021", "2345645"
INPUT "0064212345645 " would retrun "64", "021", "2345645"
INPUT "0212345645" would retrun "64", "021", "2345645"
Has anybody done this?