Given the data available in OrigName column I'm interested in arriving at CleanName values.
This is currently achieved with syntax:
UPPER(REGEXP_REPLACE([OrigName], '[^a-zA-Z]', ''))
My desired syntax would correspond to:
However, this returns NULL.
I would like to know why regex [a-zA-Z] is syntactically correct for defining set of letters to extract.egexa-zA-Z]
The correct syntax to use "REGEXP_EXTRACT" is:
You have to enclose your reg_ex expression in "()".
You can refer below link for details explanation: