Becky Edwards

asked on

# Make 9 digit zip code a 5 digit zip code

Is there a function that takes a zip code field that is currently XXXXX-XXXX and automatically

formats it to XXXXX?

If not, what could I put in the formula so that Crystal only sees, and groups by, the first five

digits only?

formats it to XXXXX?

If not, what could I put in the formula so that Crystal only sees, and groups by, the first five

digits only?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Worked perfect. Thanks!

ANother way would be to use the split command

Split({YourField},'-')[1]

mlmcc

Split({YourField},'-')[1]

mlmcc

ASKER

Thanks mlmcc!

select left(zipcodeField,5) as ZipCode