6 Replies Latest reply on Feb 24, 2012 8:08 AM by DeniseUhlenhake

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

    ClaraDalzell

      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.