I have a text field in a table server, where user Notes are stored. This data is stored in RTF format, when I pull this data from this table, the rtf tags are also displayed.
Is there a way to strip of those rtf tags and display only user notes in plain text?
You'll need a function in your database to do that. Depends upon the database. Start searching your favourite forum for your DB.
Solved with a user defined function. In case anyone has a similar problem, here is a function that worked for me (SQL Server 2019 Standard), found on GitHub
(VERY simple SQL RTF to TXT converter primarily to convert Act notes to plain text · GitHub)