RegEx Expression Needed

Good afternoon!

I have been trying to work out a RegEx parse expression for the below example however I've had no luck with working it out. Please may someone help in confirming which expression should be used?

I am looking to parse "= ABC or Above".

Example:

(Category (Lowest, Multi Org, Local/Regional, In or Out) = ABC or Above)

Thank you!

Regex

Parse

Accepted answers

alexnajm

Got it, that's why I wanted to make sure because there had to be something more to it 😊 this worked for me!

Screenshot 2025-07-15 092436.png

All comments

alexnajm

What is the logic to parse it out? Anything after an equals sign?

Providing more examples may also be helpful

Deano_280

Hi Alex - I'm looking to extract "= ABC or Above".

So I'm not looking to have anything before the = sign, nor am I looking to have the bracket after word Above included.

Other examples follow the same logic, although the full string of data would be something like:

(Country Of Origin in (FRANCE, GERMANY, AUSTRIA, NETHERLANDS)) and (Local Currency in (Euro)) and (Category (Lowest, Multi Org, Local/Regional, In or Out) = ABC or Above) and (Days Until Review is less than 10950)

alexnajm

If you are just looking for those keywords, can you just do:

IF contains([phrase], "= ABC or Above" THEN "= ABC or Above" ELSE Null() ENDIF?

Not sure you need a RegEx statement if you are just extracting the words... if this is not the case can you please provide further clarity on what's needed (ideally with examples)?

Deano_280

I'm afraid I'm not allowed to share the full data set, so the example above is modified.

Apologies I should have been clearer. The "= ABC or Above" section will vary depending on the row, specifically the ABC part so, for example, the next row may be = BBC or Above. The data set itself currently contains around 25k rows which will soon be growing, so I'm looking for an expression which will consistently pull out this section.

alexnajm

Got it, that's why I wanted to make sure because there had to be something more to it 😊 this worked for me!

Screenshot 2025-07-15 092436.png

Deano_280

This is brilliant - thank you for the help and patience!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703