Support 805.461.7300
Sales
Our Technology. Your Success.

Export as tab delimited text with a header

COPY TO "c:\output.txt" TYPE CSV
SELECT * FROM (ALIAS()) WHERE .F. INTO CURSOR _convtotab READWRITE
APPEND FROM "c:\output.txt" TYPE DELIMITED
COPY TO "c:\output.txt" TYPE DELIMITED WITH TAB

To export as tab-delimited text with quotes, use:
 

COPY TO "C:\TEST_WITH_QUOTES.TXT" TYPE DELIMITED WITH TAB

To export as a tab-delimited WITHOUT quotes, use:
 

COPY TO "C:\TEST_WITHOUT_QUOTES.TXT" TYPE DELIMITED WITH "" WITH TAB

To export as semicolon-delimited text without quotes, use:

copy to c:\test.txt fields first,last DELIMITED WITH "" WITH CHARACTER ';'

To export as tab delimited text and specify the fields you'd like to export, alter your command in this fashion:

copy to c:\test.txt FIELDS first,last,company,address,city,st,zip DELIMITED WITH "" WITH CHARACTER TAB

« Back to Commands

Your technical staff is very good! Everyone I have live chatted with has, for the most part, solved the issue on the first pass.
T.R., Dothan, AL