Start a new topic

Need Regular Expression

I need a regular expression to add a gift subtype dependent on the donor's State of residence. What I need is assign a specific gift subtype for any state that "does not equal WA, OR, ID".


Does anyone know of an expression for "not one of"?



After testing I found that I needed to tweak the expression a bit. This works well for assigning a value for any state that is not WA, OR, ID.


Expression: ^(([^WA|OR|ID])+$)

Replacement Value: GiftSubtype
Value to Match: ^(?!(WA|OR|ID)$).*
Login or Signup to post a comment