[RBASE-L] - Re: How do I make NULL truly NULL?

[Rachael Malberg]

ah hA!!
that's where the ASCII setting is!!

okay Matt try...

SET NULL ' '
OUTPUT test2.csv
UNLOAD DATA FOR ContactAddress AS ASCII
OUTPUT SCREEN
RETURN

if you change the CSV to ASCII works OR if you do..

set null ' '
GATEWAY EXPORT CSV test.CSV +
SELECT * FROM ContactAddress OPTION COL_NAMES Off +
|QUALIFIER |SEPARATOR ,|blank_if_zero on

use the 'blank_if_zero on' 

both worked for me.

Have a Fabulous Day!
Rachael M.
Freelance Developer
www.DragonflyDevelopmentMN.com
  ----- Original Message ----- 
  From: [EMAIL PROTECTED] 
  To: RBASE-L Mailing List 
  Sent: Monday, March 31, 2008 3:41 PM
  Subject: [RBASE-L] - Re: How do I make NULL truly NULL?


  I think you have a quotes problem?  Your "set null" statement in your first 
line shows a single quote, but in your example of the output it uses a double 
quote.  If your settings are a double quote, then you want to:  set null " "  
(single space between the double quotes)


    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