Re: convert rtf to plain text
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Wed, 12 Sep 2007 13:13:45 -0400
The 'RICHTEXT.RichtextCtrl' ActiveX control might be the Microsoft Rich
Textbox Control 6.0 (from VB6) that you can download from the following
page:
http://www.mediamonkey.com/wiki/index.php/Scripting_Resources
or:
http://activex.microsoft.com/controls/vb6/RICHTX32.CAB
You might have some permission issue running this from SQL-Server, I don't
know.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"tinique" <u37370@uwe> wrote in message news:7815a97b70b90@xxxxxx
can anybody please tell me how to use below sql function.I have a
requirement to convert rtf formatted string as plain text from sql
table.I found below sql function in google search. but I dont know how
to use this.what is 'RICHTEXT.RichtextCtrl' ?
CREATE function dbo.RTF2Text(@in varchar(8000)) RETURNS varchar(8000)
AS
BEGIN
DECLARE @object int
DECLARE @hr int
DECLARE @out varchar(8000)
-- Create an object that points to the S
-- QL Server
EXEC @hr = sp_OACreate 'RICHTEXT.RichtextCtrl', @object OUT
EXEC @hr = sp_OASetProperty @object, 'TextRTF', @in
EXEC @hr = sp_OAGetProperty @object, 'Text', @out OUT
EXEC @hr = sp_OADestroy @object
RETURN @out
END
GO
How can I run in the SQL server? Need to download RICHTEXT.RichtextCtrl
activeX?? THANKS!
.
- References:
- convert rtf to plain text
- From: tinique
- convert rtf to plain text
- Prev by Date: convert rtf to plain text
- Next by Date: Re: Future of ADP's - Pivot Tables
- Previous by thread: convert rtf to plain text
- Index(es):
Relevant Pages
|
