AnsweredAssumed Answered

Extracting phone numbers from imported text field

Question asked by sccardais on Apr 8, 2014
Latest reply on Apr 9, 2014 by philmodjunk

Title

Extracting phone numbers from imported text field

Post

     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.

      

Outcomes