RegEx Expression Needed

[Deano_280]

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!

[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 · Accepted solution]

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

[Deano_280]

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