Extracting text from RTF data

[RichardHayes]

I have lots of RTF strings in a table, and I would like to manipulate just the text that is contained in the string.

Does anybody know of a way of extracting the text without all the control characters that sit around it?

Saving it as a text file and opening in Word is not sufficient, I need this all to be done in SQL as I have thousands of rows.

Thanks.

Richard.

 

[NoCoolHandle]

if I am correct and you are using a text or image field, using the replace function might be your only option..

What I would probably try first would be converting the text in segments of 8000 characters to a character datatype, but this is new territory for me..

Good Luck and let us know if you have any success other than not doing some saveas stuff before you bring it into SQL.

(from my programming background, I would first try to do some kind of SaveAs with Word using remote automation (COM) before I did the save/import to SQL Server)

Rob