Alastair, I thought the same thing and tried those as well… no luck. I am sure the PIPE is reserved by the system and cannot be used in the gateway command, But Steve’s idea is a perfect workaround.
n 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]<http://mail.whitewolftechnologies.com/cgi-bin/compose.exe?id=01ef7f9322f8a76400dacb6a1fe342bb5a7&new=&xsl=compose.xsl&[email protected]> From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Tuesday, April 12, 2011 1:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Export Question You could try two pipes with no space and/or add another option that confirms a parameter that you don’t need changed. I suspect R:Base is expecting something to follow your pipe... Regards, Alastair. From: Frank Taylor<mailto:[email protected]> Sent: Tuesday, April 12, 2011 5:50 PM To: RBASE-L Mailing List<mailto:[email protected]> 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.exe?id=01ef7f9322f8a76400dacb6a1fe342bb5a7&new=&xsl=compose.xsl&[email protected]<mailto:[email protected]%3chttp://mail.whitewolftechnologies.com/cgi-bin/compose.exe?id=01ef7f9322f8a76400dacb6a1fe342bb5a7&new=&xsl=compose.xsl&[email protected]>> _______________________________________________________________________ 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]<mailto:[email protected]> - 617-790-3093. _______________________________________________________________________
