I'm looking to use regexp_replace in 11gR2 to remove start and end tags in a CLOB where the start tag is =" and the end tag is ".
For example, the content could be:
First ="Second" Third"3rd" ="Fourth" Fifth
and the desired output would be:
First Second Third"3rd" Fourth Fifth
This can't be a standard replace because that "3rd" needs to stay as-is in the output.
I've tried:
select regexp_replace(:string, '="(?:(?!").)*', '') from dual;
but this leaves the end tag:
First Second" Third"3rd" Fourth" Fifth
Thanks,
Todd