Try quoting the semicolon
Albert
On 15/11/2011 10:17 AM, Frank Taylor wrote:
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
