Struggling with Rich Text Field

Occasional Visitor

Hello Community,

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:

 

Faizan_Naeem_0-1593416583416.png

 

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&#160;Under Tech. Procurement&#160;-&#160;Pending PR Creation
<div class="ExternalClass1A849FEC18A44CCE90E425ED0F54A1A2"><html> <p>​One time Support Request.<br></p></html></div>&#160;</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.

 

https://www.codeproject.com/Tips/821281/Convert-RTF-to-Plain-Text-Revised-Again

 

https://social.msdn.microsoft.com/Forums/en-US/143abeb5-f98a-4b47-a746-dd141bdd6df7/sql-query-to-ret...

Any help on this issue will be very much appreciated.

0 Replies