I did try it as CSV, RTF and XLS all with same results 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 [email protected] Sent: Tuesday, November 15, 2011 12:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Export Command I'm surprised that you can even specify a separator for a "tab" export. By definition, the fields are separated by a "tab" character! Have you tried a "csv" export with the separator? That's the only place I've ever used it. Karen In a message dated 11/15/2011 11:18:24 AM Central Standard Time, [email protected]<mailto:[email protected]> writes: Cannot figure out what I am doing wrong.. I need to export a file with Semicolon as the delimiter (Separator) Here is the command I am issuing GATEWAY EXPORT TAB c:\pdfout\taptest.txt SELECT * FROM tapfile OPTION COL_NAMES ON|SEPARATOR ;|show_progress ON First the Show progress Option does not come up, and second the file that comes out has no separator, same if I export using csv. If I change the separator to anything else, like , or ^ or PIPE it works like it should. I even tried |Separator semicolon and got S as the separator. What am I missing This is RB 9.1.5.11111
