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
