Hello,
Right from the help file:
COPY TO mytxt.txt DELIMITED WITH _ WITH CHARACTER ';'
so why do I get a syntax error with:
COPY TO (tcOutputPath) DELIMITED WITH BLANK WITH CHARACTER |
Just so you don't have to look it up in the help file:
DELIMITED WITH CHARACTER Delimiter
Creates a delimited file with all fields enclosed by the character specified with Delimiter. If Delimiter is a semicolon (the character used in Visual FoxPro to indicate command line continuation), enclose the semicolon in quotation marks. You can also specify the BLANK and TAB keywords for Delimiter.
Note that the WITH Delimiter clause can be combined with the WITH CHARACTER clause. For example, the following command creates a text file with character fields enclosed by underscores and all fields delimited from each other with semicolons:
COPY TO mytxt.txt DELIMITED WITH _ WITH CHARACTER ';'