Strip rtf tags from text field

1

Hello everyone,

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?

Thanks

Data saved in rtf
Data saved in rtf1508×491 49.6 KB

2

You'll need a function in your database to do that. Depends upon the database. Start searching your favourite forum for your DB.

1 Like
3

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)

1 Like