Hello,
I am trying to write a Reg Exp that removes any string starts with "&" and Ends with ";" . In other words, I am trying to remove anything similar to:
& nbsp; & quot; & lt; & gt;
Any help please.
This does not work:
select regexp_replace(ename, '^&[a-z]{2,4}[;]$') from emp;
Regards,
Fateh