Remove characters before ( in snowflake

Question

I wanted to remove any character before ( in snowflake. For example: If the data has "Hello(World)", I want only "(World)".

Answer 1

Using SUBSTR and CHARINDEX functions:

CREATE TABLE tab AS SELECT 'Hello(World)' AS col;

SELECT SUBSTR(col, CHARINDEX('(', col))
FROM tab;
-- (World)

Answer 2

You can use the regexp_substr function to extract text and use a greedy expression:

set str = 'Hello (world)';

select regexp_substr($str, '\\((.+)\\)');

Answer 3

I'm a big fan of SPLIT and SPLIT_PART

CREATE TABLE tab AS SELECT 'Hello(World)' AS col;

SELECT '(' || SPLIT_PART(col, '(', 2)
FROM tab;
-- (World)