Start a new topic

Contain string Partial replacement RegExp needed

Hi, we are building a dictionary that using the Fund name will populate the Campaign name, see chart below but to avoid having to update this every fiscal year we would like to use a contain expression

Current Solution (need to update every year)

IF Fund is: FY15 Membership/FY16 Membership/FY15 Annual Fund/FY16 Annual Fund

THEN Campaign is: Membership

&

IF Fund is: Founding Member Camp

THEN Campaign is: Capital Campaign2015

 

Ideal Solution, no updates needed EVER!

IF Fund Contains: Founding

THEN Campaign is: Capital Campaign2015

&

IF Fund Contains: Mem  

THEN Campaign is: Membership

 IF Fund Contains: Ann  

THEN Campaign is: Membership

 

 SIMILAR CASE WITH LETTER CODES

 

Current Solution (need to update every year)

IF Fund is: FY15 Membership/FY16 Membership/Founding Member Camp

THEN Letter Code is: Mem

&

IF Fund is: FY15 Annual Fund/FY16 Annual Fund

THEN Letter Code is: Ann Fund

 

Ideal Solution, no updates needed EVER!

IF Fund Contains: Mem

THEN Letter Code is: Mem

&

IF Fund Contains: Ann

THEN Letter Code is: Ann Fund


This should be pretty straight-forward.

The first one would be:
Value: Capital Campaign 2015
Match: .*Founding.*
Use RegEx: TRUE

The others would be very similar!
you are missing the periods

.*Founding.*

Period-Start-"Founding"-Period-Star
Got it! thanks, all set
Login or Signup to post a comment