Start a new topic

replace all numbers except "1" with one value, and "1" with another value

Hi,

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"?


Thanks!



1 Comment

Carolyn, I've looked at your question a couple of times and am not sure I fully understand.  Can you better explain.  Thanks, Dennis

Login to post a comment