Thanks Bill - what I would like to do is to write the text out to a Word document, with some other columns, so that each row from R:Base can be put into a table in Word, however this seems not to be as easy as one would hope. I had tried the printing to an RTF option which did work, but then getting it all into the table was not that straightforward. (I thought that using R:Base to collate all this information and providing a report as a pdf was working well until the Client decided they wanted it in Word with a few extra columns added.) I think I need to talk to Razzak next about his suggestion. Thank you. Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Thursday, 4 April 2013 7:20 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Exporting VARCHAR fields containing formatted text I'm not sure how you could strip out characters, but I'll bet there is a way. Bill On Wed, Apr 3, 2013 at 2:19 PM, Bill Downall <[email protected]> wrote: John, Can you print a report to an RTF file? MS Word could read that file. PRINT report WHERE ... OPTION RTF |FILENAME myfile.RTF | On Wed, Apr 3, 2013 at 2:11 PM, John Docherty <[email protected]> wrote: Bill, Thanks for your suggestion. I tried this but ended up with a lot of formatting characters plus the text. Ay ideas as to how I can just get the text, even if I lose the formatting ? Regards, John Docherty From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Thursday, 4 April 2013 1:39 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Exporting VARCHAR fields containing formatted text John, One thing you can do is SELECT varcharcol INTO varcharvar FROM table WHERE ..., and then WRITE .vvarcharvar to a file named with a .DOC extension. Bill On Tue, Apr 2, 2013 at 11:09 PM, John Docherty <[email protected]> wrote: I need to export data in a VARCHAR column, containing formatted text, to a WORD document. To date my attempts have been unsuccessful. If anyone can let me know how to do this that would be much appreciated. (9.5_64)
Thank you. Regards, John Docherty
