Steve, You win the prize for thinking outside the Box ... That worked perfectly, Thanks
-- Frank 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] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Tuesday, April 12, 2011 1:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway Export Question 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> _______________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. If you need assistance, please contact the Systems Administrator, Frank Taylor at [email protected] - 617-790-3093. _______________________________________________________________________
