04 Apr 2013 06:04 PM Quote Reply Alert
Hi Wayne,
In your dictionary you'll have these two entries:
Replacement Value 1: recurring
Value to match on 1: RD101
Regex OFF
Replacement Value 2: --BLANK--
Value to match on 2: \b(?(\brecurring\b)MATCHED|.*)\b
Regex ON
Your code in the function would look like:
If oField.Value = "LWC Ang-INT" Then
sReturn "LWC Angel"
Else
sReturn ""
End If
Return sReturn
Then you would still use your new virtual column in AN for the new constituent code but in the "function" column on the right you would select the new function you made "LWCAngel" and in the Seed column you would select the column with your input data (N in this case) which gets automatically set to oField in the custom function.
Notice that I did not set the date here, that is because you can use the option "Default new constituent code dates to process date" under the General Settings tab in your profile. That way the date will be automatically set!
Sophia Turner