Extracting phone numbers from imported text field
Is there a way / technique to extract phone numbers embedded in a text field?
Phone numbers are embedded in some of the records I just imported. They were entered randomly with no set format. I would like to extract the phone numbers and put them into a dedicated phone field.
I found a custom calculation on Brian Dunnings site but it requires the phone numbers be separated by a "." or carriage return. Mine are not.