Great Bob, Blank_if_zero is not very obvious in that it also hides nulls, so that is why I mentioned that specifically. Glald you could figure out the other details.
Gateway is a pretty slick export engine, and the help is pretty good too on this one. 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 5:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: CSV and Null unload question Close! However double quotes popped up using the CSV option. Example using the Gateway Export CSV with Blank_if_zero on "IN","661","No",100,,,,,,"$28.39",,,,,,,"100016842","THEHOMEDEPOT", However, I was able to get it to work using Gateway Export TAB with Blank_if_zero and SEPARATOR , options. IN,661,No,100,,,,,,$28.39,,,,,,,100016842,THEHOMEDEPOT, This big box store is very particular and the format has to be exactly as they dictate. A pure comma separated file with no quotes, no null characters, etc. Thanks for the input, -Bob ----- Original Message ----- From: "Dennis McGrath" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, March 29, 2011 4:36:58 PM Subject: [RBASE-L] - RE: CSV and Null unload question 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
