Formula to extract last word in bracket() otherwise

[#1]

Hi, does anyone know what expression i would use to achieve the following outcomes:

Basically i want the expression to look at 'GroupName' and check if there is a name enclosed in brackets (), if so then return the name inside the brackets. Otherwise just give the name.

Regards???

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

The following should work (in the script)

If(Len(TextBetween(GroupName, '(', ')')), TextBetween(GroupName, '(', ')'), GroupName) AS NewField

Hope that helps.