Razzak, Thanks for your advice. I will try that.
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, 4 April 2013 6:11 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Exporting VARCHARfieldscontainingformatted text At 12:29 AM 4/4/2013, John Docherty wrote: >Thanks for your suggestion. I tried that but I still have all of the >RTF codes in the NOTE column. Was the expectation that these would be removed? >(Or have I missed the point here ?) John, In that case, you may use the "RRtfToTxt" Plugin to convert RTF data to "plain text" format. RRtfToTxt plugin is included with R:BASE Plugin Power Pack 9.5. There are four different scenarios where the RRtfToTxt Plugin can be used: 01. When the Input/Output Data is a VARIABLE 02. When the Input/Output Data is an external FILE 03. When the Input is a VARIABLE and Output is an external FILE 04. When the Input is a an external FILE and Output is a VARIABLE For complete details and examples, refer to R:BASE Plugin Power Pack 9.5 Help Manual, Page 60, Section 4.31. To extract the data from a table, you will need to DECLARE a CURSOR and then convert the FETCHed data into a plain text as variable, or save the result as TXT file. You may also select to store (INSERT) the data as text into a NOTE column as well. Hope that helps! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase
