DAX formula to take the string

[ktt777]

hi all, 

how can i write a DAX formula take the string inside the bracket out : 

(apple) apple -> apple 

(CW229) contract -> CW229

Thank you .

[amitchandak · Accepted solution]

@ktt777 ,

new column

var _1 = search("(",[Column], ,0)

var _2 = search(")",[Column], ,len([column]) )

var _3 = if(_1=0,1,_1)

return

mid([Column], _3, _2 -_1)