Thank you, that works like a charm. 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. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Friday, April 25, 2008 12:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How do I make NULL truly NULL? Matthew - If you are using the GATEWAY command, add the option |BLANK_IF_ZERO ON and that will make a null field just two commas with no spaces and no quotes. Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Burke Sent: Friday, April 25, 2008 1:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How do I make NULL truly NULL? Okay, so I finally got updated the latest updates/releases installed and I still get the same issue. Now it's certainly possible that I missed an email, did we ever conclude that this is a problem or an enhancement request? With the latest updates installed I run R> set null ' ' <- One space. Then I export to a csv and all null values are represented as " " <- four spaces. 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.
