AnsweredAssumed Answered

Adding dashes to telphone numbers

Question asked by Deenos on Mar 11, 2014
Latest reply on Mar 25, 2014 by Deenos

Title

Adding dashes to telphone numbers

Post

     Hi:

     I'm new to FM. I searched the entire forum, but didn't find a solution. I currently have telephone numbers in a field called Phone_work. The numbers display as 10 digit numbers with no characters. I would like to reformat all the numbers, without retyping them, to this format ###-###-####. I did a find all and thought of doing a replace field contents  with a calculated result, but I have no clue what is the right script.

     Your help is greatly appreciated.

     DPG

      

Outcomes