Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-25 : 08:53:14
|
| braindeadbeachbum writes "Hi GuysI depend on a wordpad app to input RTF text to a SQL database. I then read the text field from the DB via a ADO recordset into Excel using nvarchar for the RTF text field. The text I get back looks like the following:====================================================================={\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil MS Sans Serif;}{\f1\fnil\fcharset0 MS Sans Serif;}{\f2\fswiss\fprq2\fcharset0 Arial;}}{\colortbl ;\red0\green0\blue0;}\viewkind4\uc1\pard\cf1\lang1033\f0\fs20 SPOKE RIETTE AND INFORMED HER THAT CALLS WERE LOGGED INCORRECTLY I GAVE HER A NUMBER TO HELP HER OUT \par \par THE PRINTER IS FAULTY \par \f1 called and confirmed with the user that the call can be closed.\par \f2\fs18 \par }=====================================================================All I want is the actual text:=====================================================================SPOKE RIETTE AND INFORMED HER THAT CALLS WERE LOGGED INCORRECTLY I GAVE HER A NUMBER TO HELP HER OUT THE PRINTER IS FAULTY called and confirmed with the user that the call can be closed. =====================================================================I know it’s a long shot but is there any way I can specify in my SQL query that I will be reading RTF and that it should edit the RTF and only supply the actual text?Please help!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-25 : 08:55:15
|
| It's not something that's built into SQL Server, you'd need an external program that can read RTF and extract just the text.Might be worth thinking about a new user interface, or at least stripping the formatting out before storing the text in the database. |
 |
|
|
|
|
|
RTF - SQL