If you export using Gateway, CSV files have TEXT fields enclosed in double quotes, even if your quote setting is single, because that is the standard.
using the gateway command is not the same as unload data AS xxxx. When I set the null character to the ASCII value for Null, Char(0) and unload a table with nulls, this is the output: PhNo,Col2,Col3 ,"One","Two" ,, "260-637-9999",, ,"One One","Two Two" ,"one One One", "260-637-9999",,"Two Two" The first row first col is a null the second all nulls the third, Col2 and Col3 are nulls etc. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, March 31, 2008 4: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 > > > >
