How can I remove characters in a string after a specific special character in snowflake sql?

Question

I have a url column in my database. I want to remove all characters after ? .

select regexp_replace(page_url,'?(.*)', '') as clean_url from demo

But I’m getting the following error: Invalid regular expression: ‘?(.*)’, no argument for repetition operator: ?

Answer

Using LEFT and CHARINDEX:

SELECT IFF(CHARINDEX('?', page_url)>0,
           LEFT(page_url, CHARINDEX('?', page_url)),
           page_url) AS clean_url 
FROM demo

Accepted Answer

Using LEFT and CHARINDEX:SELECT IFF(CHARINDEX('?', page_url)>0,           LEFT(page_url, CHARINDEX('?', page_url)),           page_url) AS clean_url FROM demo

Advertisement

Answer