Could you use a Report?
Then Print to a file.
----- Original Message -----
From: "MikeB" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, January 19, 2009 4:50 PM
Subject: [RBASE-L] - Re: Unload / Export VARCHAR columns
Use a cursor and WRITE. You are likely going to have to think around the
crlf and lineends, maybe massage the data with SRPL before WRITEing.
----- Original Message -----
From: "Lawrence Lustig" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, January 19, 2009 4:30 PM
Subject: [RBASE-L] - Unload / Export VARCHAR columns
I'm beating my head against something that I feel must be very easy.
I have a table that I defined with some LONG VARCHAR columns to hold what
in the old days would have been NOTE fields. I want to export from this
table to Excel.
So far I've tried GATEWAY (produces "<BLOB>" instead of the text in the
columns), SELECT AS CSV (produces "Cannot unload VARCHAR as ASCII",
BROWSE and then Export from the menu (same <BLOB> problem), and BROWSEing
a computed version of the column (BROWSE SGET(ProbVarChar, 50, 1)) which
crashes R:Base (but bigtime).
Please point me in the right direction.
--
Larry
