I'm not sure if this is the same issue, but I think Regex_Extract has a little bit different syntax
with an extra set of parentheses:
If that doesn't help, would be grateful if you would post some sample data
from which you are extracting.
See below , this is working:
U need to add parenthesis around the regex pattern.