I think the reason this is difficult to do is NULL is (Char(0)) and
coincidentally, RBases end of data marker (null terminated string) is
(Char(0)), so it can't be "actually" represented in output.
Is it an option to write a VBA segment in the worksheet to set a range of
cells to NULL?
----- Original Message -----
From: "Emmitt Dove" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, June 22, 2010 1:32 PM
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]
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
