Start a new topic

Regular Expression Dictionary to assign a letter based on the amount of the gift

Hi,


I have a Dictionary I use to apply a different letter code depending on the amount of the gift. Previously if the gift was $50 or more they would get a different letter, but that amount has been reduced to $42 or more. I've tried changing the regular expression, but I can't figure it out so I've been manually updating the records in the Batch.


Can you help? I've attached an export of the Dictionary.


I really appreciate your expertise.


Here's what I've got. I also attached a CSV with the information

PAW - New Letter ^(?:\d|[1-4]\d|9[0-9])(\.\d{1,2})?$ TRUE FALSE
PAW - Major New/Upgrade Letter ^(?:\d|[5-9]\d|9[0-9])(\.\d{1,2})?$ TRUE FALSE
PAW - Major New/Upgrade Letter ^(?:[1-9]\d{2}|[0-9])(\.\d{1,2})?$ TRUE FALSE
csv
(246 Bytes)
Login or Signup to post a comment