So, I am trying to create a dictionary that can translate a dollar amount to a specific letter code. Anything $1-$499 gets a specific letter, anything above $500 gets another. With the help of some superstars on staff I have gotten this far:
But in testing it is not working nicely. Thought I had it for a second, but no dice.
What am I missing?
So the last row would be value to match on ^(?!(LOW LETTER)$).* and replacement value would be HIGH LETTER