By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,660 Members | 1,593 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,660 IT Pros & Developers. It's quick & easy.

SQL Function to convert RTF to plain text

P: n/a
Does anyone have the logic to convert RTF formatted data in a text
column into plain ascii text that I can use in a varchar variable or
field?

We have an app that allows formatted comments/notes to be stored in a
SQL 2000 text column. Ideally, I would like a trigger that would copy
any inserted comments into a seperate table, varchar field so that
these are viewable in other apps that can not display formatted RTF.

I would really like the logic to be all SQL based and not have to use a
client app to read/convert/insert the data in a batch mode.

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

If you can get plain text out of the application/control then that will be
the quickest and simplest solution. As rtf format control codes are ascii
you could search and replace the control codes but there are many of them!

John

"rob.kellington at gmail" <ro************@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Does anyone have the logic to convert RTF formatted data in a text
column into plain ascii text that I can use in a varchar variable or
field?

We have an app that allows formatted comments/notes to be stored in a
SQL 2000 text column. Ideally, I would like a trigger that would copy
any inserted comments into a seperate table, varchar field so that
these are viewable in other apps that can not display formatted RTF.

I would really like the logic to be all SQL based and not have to use a
client app to read/convert/insert the data in a batch mode.

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.