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?).

 

Thanks!

Outcomes