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] 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 > >
