Oracle REGEXP_SUBSTR removing substring

Question

From every String I want to remove the substring "withHugo"

I tried

SELECT REGEXP_SUBSTR('STRING-EXAMPLEwithHugo','(.+)withHugo') "REGEXPR_SUBSTR" FROM DUAL;

but it returns "STRING-EXAMPLEwithHugo" instead of "STRING-EXAMPLE". How can I REMOVE the 2nd part?

Answer 1

You want REGEXP_REPLACE here to replace "withHugo" with an empty string:

SELECT REGEXP_REPLACE('STRING-EXAMPLEwithHugo','withHugo', '') "REGEXPR_SUBSTR" 
FROM DUAL;