04 Apr 2013 06:04 PM Quote Reply Alert
In your dictionary you'll have these two entries:
Replacement Value 1: recurring
Value to match on 1: RD101
Replacement Value 2: --BLANK--
Value to match on 2: \b(?(\brecurring\b)MATCHED|.*)\b
Your code in the function would look like:
If oField.Value = "LWC Ang-INT" Then
sReturn "LWC Angel"
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!