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
