I'm hoping for some guidance. I'm trying to create a dictionary to replace all numbers that come in a column with text, except for instances of "1" by itself (as in not "21"), which I want as another value.
I have a RegEx value to match on as: ^.+$, but that replaces all instances of numbers/text. How do I get it to replace all instances except "1", so that I can apply another replacement value to match on "1"?
Carolyn, I've looked at your question a couple of times and am not sure I fully understand. Can you better explain. Thanks, Dennis