Regex to include a pattern match and not include another but not immediately following

Question

I have currently a pattern match in a query like this

if(upper(email_omni_code_mini) like '%TRAVEL%' and upper(email_omni_code_mini) NOT like '%TRAVEL%ENS%',...,...)

I want to change this to a single pattern match but this won't work TRAVEL(?!ENS) as ENS is not immediately following.

Is there a way to solve this easily.

Any help is appreciated.

If there are other chars in between, insert `.*` before `ENS`. Use `TRAVEL(?!.*ENS)` — Wiktor Stribiżew, Nov 26 '18 at 15:16
Oh okay , I was of the impression that variable no of characters wont work in look ahead. Was brushing up this after a long time. — Akshay Hazari, Nov 26 '18 at 15:19

score 1 · Accepted Answer · answered Nov 26 '18 at 15:20

1

If there are other chars in between, insert .* before ENS:

TRAVEL(?!.*ENS)

It will now match TRAVEL that is not immediately followed with any 0+ chars as many as possible followed with ENS substring.

answered Nov 26 '18 at 15:20

Wiktor Stribiżew

1 Answers1