replace all numbers except "1" with one value, and "1" with another value
C
Carolyn Simmons
started a topic
almost 3 years ago
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
D
Dennis Ladnier
said
almost 3 years ago
Carolyn, I've looked at your question a couple of times and am not sure I fully understand. Can you better explain. Thanks, Dennis
Carolyn Simmons
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!