Rachel, My Databases are still anchored in v7.6 for DOS and v7.6 for Windows. Also, I try to stick as close to SQL standards as possible. The GATEWAY syntax you show is only in the Windows version. Hence my reliance on the UNLOAD DATA command.
Jim Bentley --- Rachael Malberg <[EMAIL PROTECTED]> wrote: > Hay James, well I am using the latest version of V8 and until > I did... > set null ' ' > GATEWAY EXPORT CSV test.CSV + > SELECT * FROM ContactAddress OPTION COL_NAMES Off + > |QUALIFIER |SEPARATOR ,|blank_if_zero on > > and added the blank_if_zero, before that I couldn't get it to > work. also the |QUALIFIER |SEPARATOR ,| options, I think may > do just what it is you're asking. > > Have a Fabulous Day! > Rachael M. > Freelance Developer > www.DragonflyDevelopmentMN.com > ----- Original Message ----- > From: James Bentley > To: RBASE-L Mailing List > Sent: Monday, March 31, 2008 5:25 PM > Subject: [RBASE-L] - Re: How do I make NULL truly NULL? > > > Rachel, > Works properly for me in latest version 7.6 windows and 7.6 > DOS. > > What I would like to see is an enhancement to the unload > command > to UNLOAD DATA FOR table/view as ASCII|CSV DELIMIT=char > QUOTE=char NULL=ON|OFF > > the enhance would allow override the default DELIMITER > and/or > QUOTE character or using NULL character just for this > statement > without having to issue SET COMMANDS. This would apply to > the > output data NOT to any of the equivalent values used in > tables > or views. I would be really nice if you could also define > by > using (CHAR(##)) ON right side of Equal Sign; i.e. > DELIMIT=(CHAR(44)) > > I recently had to do a workaround when I modified a view for > data being exported Microsoft WORD. Word requires that you > use > " to enclose text that contains the DELIMIT comma that I > use. > Prior to this I would SET NULL ' ' and SET QUOTES=". When I > modified the view I put in text surrounded by SINGLE QUOTES. > Needless to say VIEW now failed because the text was not > surrounded by DOUBLE QUOTE character. I had to use the > SINGLE > QUOTE and make the correction in a text editor external to > RBase. > > Jim Bentley > > > --- Rachael Malberg <[EMAIL PROTECTED]> > wrote: > > > I seconded that. when issuing the following... > > > > set null '' > > GATEWAY EXPORT CSV test.CSV + > > SELECT * FROM ContactAddress OPTION COL_NAMES ON + > > |QUALIFIER '|SEPARATOR ,|REC_SEP CRLF + > > |SHOW_PROGRESS ON |ACTION OPENVIEW > > > > > > then open the file in note pad, all my null fields = ' > ' > > not ,, > > > > Dennis? or Steve? what is missing? > > > > ----- Original Message ----- > > From: Matthew Burke > > To: RBASE-L Mailing List > > Sent: Monday, March 31, 2008 3:04 PM > > Subject: [RBASE-L] - Re: How do I make NULL truly NULL? > > > > > > Now I'm wondering if perhaps I need to export in another > > way. I did >set null ' 'ß(there's a space between the > single > > quotes) > > > > > > > > And after doing that, using my previous example. > > > > > > > > > > a > > b > > c > > > > 1 > > text > > -0- > > text > > > > > > > > > > .is now exporting to a csv as. > > > > > > > > "text"," "ß(four spaces between the quotes),"text" > > > > > > > > Matthew Burke > > > > Pioneer Bank - IT Department > > > > Computer Systems Technician > > > > 505-627-4415 > > > > > > > > This email contains PRIVILEGED AND CONFIDENTIAL > information > > intended only for the use of the addressee(s) named above. > If > > you are not the intended recipient of this email, or the > > employee or agent responsible for delivering it to the > > intended recipient, you are hereby notified that any > > dissemination or copying of this email is strictly > prohibited. > > If you have received this email in error, please notify us > by > > replying to this email and delete this email from your > > records. Thank you for your cooperation. > > > > > > > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf > > Of Dennis McGrath > > Sent: Monday, March 31, 2008 12:10 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Re: How do I make NULL truly NULL? > > > > > > > > Matt, > > > > > > > > Have you tried exporting as ASCII when NULL = ' ' (a > space) > > > > Try it and look at the generated file. > > > > There will be no spaces between the commas for a NULL > value. > > > > This is exactly what you need. > > > > > > > > Here are my rules for the use of the NULL setting: > > > > ALWAYS have NULL='-0-' EXCEPT: > > > > When exporting data as ASCII, CSV, etc. > > > > When editing with a form > > > > When printing a report > > > > > > > > If you do not have NULL='-0-' and you edit tables > manually, > > you will never get a null entered in text fields. > > > > Try as you might, the value will always be a space. > > > > > > > > The exact opposite is true in forms. If null='-0-' not > only > > will your forms look ugly, but you won't know the > difference > > between NULL and '-0-' > > > > > > > > When Unloading data and structure from RBASE, ALWAYS set > > NULL='-0-' > > > > > > > === message truncated === Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Special deal for Yahoo! users & friends - No Cost. Get a month of Blockbuster Total Access now http://tc.deals.yahoo.com/tc/blockbuster/text3.com
