Start a new topic

Regular Expression string ends

Hello All,


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:


e_s18_jan_membershiprenewalmatch_c4

e_main_staffdonationpage_c3


Would appreciate any help.


Thanks,

Denise


Hi Denise,


Can you export your dictionary to a CSV and post it here?  To export just right click on the dictionary name and select export.


Thanks,


John

Hi John,


Dictionary is attached.


Thanks1

csv
(149 Bytes)

Hi Denise,


Try using ^$ or \A\Z instead of -- BLANK --. That should do it.


Regards,

Aleksei

Hi Aleksei,


That worked! Thanks so much.

Login or Signup to post a comment