3 Replies Latest reply on Jun 14, 2010 4:44 PM by holgerhelmut

    Need auto calculation to format phone number field to insert dashes

    holgerhelmut

      Title

      Need auto calculation to format phone number field to insert dashes

      Post

      I have a database with 10,300 US records. The text field "PhoneNumber" needs to be auto re-formatted. Currently the numbers are all 10 digits without any spaces but also without the desired dashes. Meaning numbers are listed as 2136223750 and I need them to read 213-622-3750. 

      I can't figure out the auto calculation. Anyone?

      Super thanks.

       

      Os: Mac OS 10.6

      FileMaker Pro 11