Jump to content

Phone numbers & zip codes


This topic is 6459 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 6459 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.