Now that you've shared both lines I see the issue. Regular expression values cascade. So when you enter 190160 in the test it is converting it to 00001-593-0000375159. Then it gets to the second row and its not analyzing 190160 anymore because it has been converted to 00001-593-0000375159. Since 00001-593-0000375159 does not equal 190160 it converts it to 69997. To correct this your second line value to match on needs to be your first line's replacement value so your second line value to match on needs to be ^(?!00001-593-0000375159).*$

Thank you for your input. I tried that already and that doesn't work. The dictionary is supposed to give me 00001-593-0000375159 when I enter 190160, but it gives me 69997 when I enter it using the formula you supplied. My other formula was the closest to working of all I tried. WIth the formula you gave I get 69997 no matter what I enter, including 190160.

Here is the other part of the dictionary, FYI. With your reg expression added in, it completely ignores this. With my formula, this part works, even though the second part is only semi-working.

Hi Jana,

It looks like you need to adjust your value to match on slightly. It needs to be ^(?!190160).*$

Thanks,

John

Help Desk Software
by Freshdesk Support Desk

## Jana Birckbichler

Okay, what am I doing wrong?