Regex Help

[PN2527]

I have a field that contains data like below. I need to extract 'CTO' from that field.

Example:

A (CTO)

Ast (CTO)

Ktre (CTO)

Box (CTO)

[ChrisTX · Accepted solution]

Use the RegEx tool in Parse mode

[MarqueeCrew · Accepted solution]

@PN2527 ,

 please try this instead of regex:

IIF( Contains([field],"CTO"),"CTO",Null())

 cheers,

 mark