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