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
