Extracting values Within The Parenthesis

[rohit_bibe07]

Hii,

I want extract values within the parenthesis, suppose (US)-US , (AM)- AM like that.

[pooja_prabhu_n]

Hi,

Try PurgeChar(yourfield, '()')

[MarcoWedel]

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

[Schaefer]

To extract the text between any characters, use a formula with the MID and FIND functions. The FIND Function locates the parenthesis and the MID Function returns the characters in between them.

My Apron