Forum Discussion
Strip rtf code and html tags from text
I have a text column (in a sql database) that contains a lot of rubbish. I discovered 2 things I want to get rid of: 1. rtf code like this: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fni...
Go through Text Functions (DAX), Text functions (Power Query) and String Functions (Transact-SQL). You may also get help from the MSDN Transact-SQL Forum.