AnsweredAssumed Answered

Remove first character in imported text string

Question asked by drewmurrie on Jun 19, 2012
Latest reply on Jun 19, 2012 by 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

Outcomes