Dennis,
That resulted in an XLSW with one space in each "empty" cell, and an XLS with four spaces in each "empty" cell. 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 Dennis McGrath Sent: Tuesday, June 22, 2010 13:54 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: NULL setting Try SET NULL ' ' - one space between quotes Your syntax does not change the NULL setting. I believe the NULL must be 1 to 4 characters. Dennis McGrath _____ From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Tuesday, June 22, 2010 12:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - NULL setting 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]
