Bill,
The BLANK_IF_ZERO did the trick. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Tuesday, June 22, 2010 13:43 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: NULL setting Emmitt, I think GATEWAY re-reads the RBwhatever.CFG file when you start it. But the DIALOG version has a checkbox for Export as Blanks. Seems like there should be an "OPTION" to match, like BLANK_IF_ZERO, only BLANK_IF_NULL Bill On Tue, Jun 22, 2010 at 1:32 PM, Emmitt Dove <[email protected]> wrote: Folks, I'm using 7.6 to do a GATEWAY EXPORT to an XLSW. Our databases run with the NULL character set to a single dash, or (CHAR(45)). In the worksheet I need null columns to be completely empty. Here's what I've tried: SET NULL '' -- two quote marks, nothing between them GATEWAY EXPORT ... SET NULL '-' The problem is that the worksheet still contains dashes where the column was null. How do I get those columns to be truly empty? Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected]
