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"?

Thanks,

Bill


Replacement Value: GiftSubtype
Value to Match: ^(?!(WA|OR|ID)$).*

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])+$)

Login or Signup to post a comment