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 |
