How to get string between parenthesis?

Abhi1540

Hi Experts,
I have a string between 2 parenthesis. how to get the string between 2 parenthesis as follows

my input is: (success)

output will be only success

how can i achieve this??

marcothesane

WITH input(s) AS (SELECT '(success)' )
SELECT REPLACE(REPLACE(s,'(',''),')','') FROM input;

Jim_Knicely

You can also use the TRANSLATE function:

dbadmin=> select translate('(success)', '()', '') "What's inside the Parentheses?";
 What's inside the Parentheses?
--------------------------------
 success
(1 row)

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/TRANSLATE.htm