Bo, What I meant is exporting data by using the old fashioned Write command, it looks like this:
OUTPUT <filename.txt> WRITE <.variable_name> OUTPUT SCREEN It is very flexible, but some programming is needed. The question is what do you like to do with the exported material. If you like to publish it in a PDF, just create a report and print it as a pdf or RTF if you like. Just play around a bit Printing as RTF looks like this: print test OPTION RTF |FILENAME test.RTF Tony From: [email protected] [mailto:[email protected]] On Behalf Of Bo Franzén Sent: donderdag 9 oktober 2014 15:53 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Exporting LONG VARCHAR columns to Excel or Word Hello Toni, Nice to hear from you, and nice to meet you in Baden! Yeas the columns only contain text, one in Medieval Latin and one in Swedish translation. I must admit that I didn't know that exporting from a form is possible. I realise that exporting must be possible from the R>prompt, maybe in any format you like. But I see no .txt-alternative when right clicking on the table or the view in order to export. Bo Franzén Department of Economic History Stockholm University _____ Från: [email protected] [[email protected]] för Tony IJntema [[email protected]] Skickat: den 9 oktober 2014 14:01 Till: RBASE-L Mailing List Ämne: [RBASE-L] - RE: Exporting LONG VARCHAR columns to Excel or Word Bo, As always there are 100 solutions for a problem at least in Rbase - . A Long Varchar could contain almost everything, so yes there could be a problem exporting it to excel or word. If in your case the column only contains text (using the note /Varchar option in the Blob) you are able to export it to a file as .txt or something like similar. Another solution might be to export it in a report. Pay attention to the stretch option in the advanced rich edit. Hope this helps Tony IJntema Holland From: [email protected] [mailto:[email protected]] On Behalf Of Bo Franzén Sent: donderdag 9 oktober 2014 13:30 To: RBASE-L Mailing List Subject: [RBASE-L] - Exporting LONG VARCHAR columns to Excel or Word Hej R:BASE! I'm back in research using relational databases, i.e. R:BASE - great! I have a data base with a table containing two text columns that in some cases are pretty long, so I predefined them in LONG VARCHAR when I created the base five years ago or so. But when exporting those two columns from the table to Excel or Word, some of the longest text parts are lost (e.g. ########### in word). I've tried to make a view of the whole table and export from there, but the problems remain. I have not tried to change the two LONG VARCHAR columns into TEXT yet, but could that be an opportunity nowadays? Bo Franzén Department of Economic History Stockholm University
