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

How can we help you today?

Start a new topic

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

Sarah Martin

started a topic over 1 year ago

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

Letter Code-...

(246 Bytes)