AnsweredAssumed Answered

Parse Phone Numbers from Text

Question asked by fmdataweb on Feb 19, 2017
Latest reply on Feb 19, 2017 by Philip_Jaffe

I have a general notes field where users have entered in phone numbers and other text, for example:


Home: 123 456 7890 Mobile: 987 654 3211 best to call after 5pm


I'm trying to come up with a method to extract the phone numbers from the text so I can move them to dedicated phone number fields in a looping script, but I'm stuck on how I can identify where a phone number starts and ends (given there can be multiple phone numbers in the text field).


Anyone been down this road before or know of a solution (recursive custom function etc?).