Okay, never mind. It finally came to me. Instead of using the OUTPUT...AS
ASCII command, I used the GATEWAY EXPORT command, and it worked the way I
needed. I'm getting old, and my memory just isn't what it used to be.
Lynn Shelton
El Paso, Texas
It's been so long that I have done this that I have forgotten how! I have
been asked to modify an old program that I wrote in R:Base 6.5+ -- I know,
old and obsolete, but the customer likes what they have and they are not
yet ready to upgrade to the latest and greatest yet.
Anyway, I need to output several comma delimited files from within the
program code. These files will then be imported into Microsoft Excel and
Microsoft Access for further processing and eventual XML data file uploads
to a private web site.
My problem is I can't seem to remember how to get the Null value setting
to output literally nothing if a value is null. I need absolutely nothing
between the commas in the comma delimited files if the value is null. No
matter what I have tried, I get some spaces between the commas.
I have done this before, but it has been several years, and I can't seem
to find the old code where I did it. I am sure I can eventually remember
and get it working, but I am on a tight deadline -- test upload of data to
the web site has to be done this week -- so any help that can get me
moving quicker with this problem will be greatly appreciated!
Thanks,
Lynn Shelton
El Paso, Texas
--- 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.
================================================