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 Aleksei,


That worked! Thanks so much.

Hi Denise,


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


Regards,

Aleksei

Hi John,


Dictionary is attached.


Thanks1

csv
(149 Bytes)

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

Login or Signup to post a comment