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 ';'


>All:
> I have a table and from the table I want to convert the data to TAB DELIMITED text file. From Fox, I use the COPY TO function to create the TAB DELIMITED file. Question: I need to delete the " " that appears in my text file periodically. I want a TAB DELIMITED file only on both character and numeric values without any
>quotation marks around them.
>
> P.S. I already tried .sdf format.
>
>Thank you
>MA