Delete the last 5 characters in a field

Question

I am trying to delete the last 5 characters in a field.
Example: MAPLE GROVE MN  55369-3466
I want to delete "-3466" where -3466 is not the value in all records.

~Julie

Zeke · Answer

Looks ok to me...but try it on a copy first, I don't know your data like you do.

JulieHines · Answer

With the caveat I posted above:

1. In field calculator, switch the parser to Python.
2. Double click your field in the list to enter it in the calculation box.
3. Click =
4. Doubleclick your field again.
5. Add this to your field in the calculation box, no spaces between the fieldname and the following: [:-5]
6. Click Ok.

Maybe try this on a copy of your data first, just in case.

Does this look correct?

!OWN_ADD_L2! = !OWN_ADD_L2![:-5]

Zeke · Answer

So what if I want to delete the last 5 characters of every record in a field?

With the caveat I posted above:

1. In field calculator, switch the parser to Python.
2. Double click your field in the list to enter it in the calculation box.
3. Click =
4. Doubleclick your field again.
5. Add this to your field in the calculation box, no spaces between the fieldname and the following: [:-5]
6. Click Ok.

Maybe try this on a copy of your data first, just in case.