Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

My question is when zip codes are entered with 5 numbers and then the new 4 numbers but wihtout the hypen is there anything you can do to automatically enter the hypen without going through all the data? I am self teaching, new and getting frustrated. ex:48825-4801 (?)

Thank you

Posted

You can use this formula to check for and insert the hyphen:

Case(Length(ZipCode)>5 and PatternCount(ZipCode,"-")=0,

Left(ZipCode,5) & "-" & Middle(ZipCode,6,4),

ZipCode)

You can either use this formula in a new calculated formatted zip code field, or as the formula in a replace command to replace the original data in the same field. If you are going to directly change the original data, make sure you back up your file first.

This topic is 8249 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.