Frank, This not using Gateway, but it will work.
set delimit=null set delimit=| out testemp.csv unload data from employee as csv out screen set delimit=null set delimit=, return Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: Tuesday, April 12, 2011 9:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway Export Question We have a new customer that wants a flat file sent to them with the fields separated by the | (Pipe) symbol and no quotes. I thought this was going to be very simple, but I am having an issue where it is giving me blank (No separator) instead of | Here is the command I am using gateway export Tab p:\durgin.txt select * from quotetable option COL_NAMES ON | separator | If I change it to Separator #, then that works as does other symbols. I tried putting the quotes around the pipe '|' symbol but still no luck. Any suggestions ? This is RB V9.1 Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected]<http://mail.whitewolftechnologies.com/cgi-bin/compose.ex e?id=01ef7f9322f8a76400dacb6a1fe342bb5a7&new=&xsl=compose.xsl&to=ftaylor@fjo hara.com>
