REGEXP_SUBSTR use /g flag
Hello, I am trying to extract all occurrences of a word before '=' in a string, i tried to use this regex '/\w+(?=\=)/g' but it returns null, when i remove the first '/' and the last '/g' it returns only one occurrence that's why i need the global flag, any suggestions?
0
Answers
REGEX_SUBSTR is a single-valued function, but you can call it with different values of the occurrence parameter by using a cross join.