I'm trying to create a dictionary to do the following:
If string ends with c4 = C4 Membership Transaction
If ends ends with C3 = C3 membership Transaction
If field is blank = C3 Membership Transaction.
.*c4 and --BLANK-- work in test.
but .*c3 does not work correctly. It enters the replacement value multiple times.
Samples of incoming data are:
Would appreciate any help.
That worked! Thanks so much.
Try using ^$ or \A\Z instead of -- BLANK --. That should do it.
Dictionary is attached.
Can you export your dictionary to a CSV and post it here? To export just right click on the dictionary name and select export.