I have a column in my table which stores a paragraph like below :
<p>**75 Licenses for Workspace ONE Enterprise about to expire in October 2023 on Prem. Targeted to be migrated to VMC on AWS, exploiting the advantages of the cloud cost, scalability, manageability wise.**</p>
I want to remove all the bold characters in the beginning (<p>) and in the ending (</p>)
so that my expected result should be like this:
75 Licenses for Workspace ONE Enterprise about to expire in October 2023 on Prem. Targeted to be migrated to VMC on AWS, exploiting the advantages of the cloud cost, scalability, manageability wise.
Thank you.
I have already tried with:
regexp_replace(
regexp_replace(
regexp_replace(replace(replace(cta.SUCCESSCRITERIA,'<p id="isPasted">',''),'/p',''),
r'<p [^<>]*>', r'(Image) '),
r'(&)([^&;]*)(;)', r'<\2>'
),r'\<[^<>]*\>', ''
)
But it resulted as this:
lt p gt 75 Licenses for Workspace ONE Enterprise about to expire in October 2023 on Prem. Targeted to be migrated to VMC on AWS, exploiting the advantages of the cloud cost, scalability, manageability wise. lt p gt