12 Replies Latest reply on Mar 25, 2014 12:36 PM by Deenos

    Adding dashes to telphone numbers

    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