2 Replies Latest reply on Jun 19, 2012 11:25 AM by drewmurrie

    Remove first character in imported text string

    drewmurrie

      I'm importing phone numbers from an comma delimitated xl spread sheet that has a one in front of the phone number.

      Eg: 17142322XXX

      Once imported into filemaker the number is used to find which vendor the call was made to. However to achieve this it must be in the format

      (714) 232-2XXX

       

      To format the phone number I have used

      Let ( Num=Filter ( Phone Number ; 1234567890);"(" & Left (Num; 3 ) & ") " & Middle ( num ; 4 ; 3) & "-" & Middle ( Num ; 7 ; 4 ))

       

      Which works fine

      I just need the part that gets rid of the 1 at the beginning

      Thanks for any Help