Phone numbers & zip codes

[Mother Barbara]

I need to learn how to format phone numbers & zip codes correctly. Once again as an MS Access user I know how but can't discover it in FileMaker. Help please!

[Lee Smith]

The question on how to format a phone number has come up many times in the past, a search of the forum for [color:blue] +Phone +Format should provide a number of hits containing the answer you desire. However, I'm curious as to what needs to be formatted in the zip codes though.

If you would post an example of both needs, in other words what you have now, and how you want it to look, we can provide better help.

Lee

[Mother Barbara]

The phone number as imported from my MS Access file:

7247528097. I want it to be readable: 724-752-8097 or

(724) 752-8097.

The Zip Code as imported came through 161173282. I want it to be 16117-3282.

Thanks!

[Lee Smith]

Take a look at this calculation by [color:blue]comment for the Phone Format. Link

and this one should do it for the zipcode:

Here is a Let calculation for the zip.

Let (

imput = Filter (zipNumber; "0123456789" )

; Case(Length ( imput ) = 5; imput;

Length ( imput ) = 9; Left(imput; 5) & "-" & Right(imput; 4)

))

zipNumber is your import field.

Be sure that the [color:red]result for [color:blue]both of these [color:blue]calculations is [color:red]text.

BTW, you could use these calculations in your existing fields using the Auto Enter Calculations.

Lee

Edited September 22, 2006 by Guest