Struggling with Rich Text Field
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: 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. 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-retrieve-a-rich-text-memo-field?forum=sqlgetstarted Any help on this issue will be very much appreciated.
