I have a SQL table which has a column containing rich text field tags. I am trying for 2 days now to get rid of the tags but nothing is working for me.
<div class="ExternalClass00D082CB77D043AC975C783B3BC9B418">PR approval process complete, currently with procurement. EU to provide the Scope and SSJ. Else Procurement with reject the PR.</div>
Below is how the text appears while in the actual website, the data appears like this:
The removal process cannot be hard-coded because every record tags are different from another. For example see the below example:
<div class="ExternalClass156752DF6D8A4BBF84D75235021E4A45">Demand status updated to Under Tech. Procurement - Pending PR Creation <div class="ExternalClass1A849FEC18A44CCE90E425ED0F54A1A2"><html> <p>One time Support Request.<br></p></html></div> </div>
*I have attached the actual output of this from website
If anyone can help me on how to clean the characters with a SQL function or maybe a C# code that will be very helpful.
I have tried the below links and they do not solve my problem.