AnsweredAssumed Answered

Need to Insert a character (-) in a string of numbers (9 digits)

Question asked by ClaraDalzell on Jun 23, 2011
Latest reply on Feb 24, 2012 by DeniseUhlenhake

Title

Need to Insert a character (-) in a string of numbers (9 digits)

Post

I have a zip code field, some of the zip codes were automatically entered without a "-" between the 5th and 6th digit in the 9 digit zip codes.  I'm pretty sure I need to write a script or calculation or both to add a character into the middle of the string of digits, but I'm not very familiar with the formulas and functions in the calculations list.

Could someone assist me with how to go about adding a character in the middle of a string?

Thanks.

Outcomes