The 'BLANK' option can only be used as a field separator. If you want to surround fields with spaces
COPY TO (tcOutputPath) DELIMITED WITH " " WITH CHARACTER |
>
>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 ';'
--sb--