AnsweredAssumed Answered

Can I do a Search and Replace in a number data field?

Question asked by MikeS on Jan 5, 2012
Latest reply on Jan 5, 2012 by Mike_Mitchell

I have a field that is unique and it contains: five digits, a hyphen and two digits. 12345-12. The last two digits represent the year. The first five are the membership number. I want to to remove the hypen and leave the 5 digits in the field and put the other two in a separate field. Any way of doing this besides doing all 5,000+ fields manually? I want to make the 5 digit field auto creat a new number on entry and then add the current year on the end. I can do that part, I don't know how to undo the original set up.

Outcomes