Matching all characters in a set

Asked May 21 '20 at 09:32

Active May 21 '20 at 09:40

Viewed 21 times

I want to be able to match != when both ! and = appear together.

I have the following RegEx pattern so far: (\'.*\')\s*([!=]|\bNOTLIKE\b|=|\bLIKE\b|\bIN\b)\s*(.*)

The following examples should demonstrate how the pattern behaves:

'DocID' = 1234 = Valid

'DocID' NOTLIKE 1234 = Valid

'DocID' != 1234 = Valid

'DocID' IN 1234 = Valid

'DocID' ! 1234 = Invalid

In its current state, ! can be entered by itself and be valid (incorrect). How can I modify my RegEx to include != as a valid input in the 2nd capture group?

edited May 21 '20 at 09:33

asked May 21 '20 at 09:32

Sam

You mean `!?=`? – Sweeper May 21 '20 at 09:33
yup, `(\'.*\')\s*(!?=|\bNOTLIKE\b|\bLIKE\b|\bIN\b)\s*(.*)` should do – Andrea Giammarchi May 21 '20 at 09:36
`/\s(!?=|(NOT)?LIKE|IN)\s/`? – Justinas May 21 '20 at 09:37
`(\'.*\')\s*(\!\=|\bNOTLIKE\b|=|\bLIKE\b|\bIN\b)\s*(.*)` ? – hacker315 May 21 '20 at 09:37
Replace `[!=]` with `!=`, the character class means you match a single char from the set. See [demo](https://regex101.com/r/naahcq/1/). – Wiktor Stribiżew May 21 '20 at 09:39

Matching all characters in a set

0 Answers0