Use GATEWAY EXPORT CSV command Use the BLANK_IF_ZERO option.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 29, 2011 4:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - CSV and Null unload question This seems it should be simple, but I am drawing a blank. I need to unload a table as a CSV, but I do not want to change my null settings and I do not want the CSV to contain the -0- character. Example of data with Unload as CSV : IN,R55B,No,100,-0-,-0-,-0-,-0-,-0-,5.12,-0-,-0-,-0-,-0-,-0-,-0-,202087564 I need it to be : IN,R55B,No,100,,,,,,5.12,,,,,,,202087564 Again, I do not want to change the null setting and I must use comma as the delimiter. Thanks, -Bob
