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 Mr. Vince Murdoch, who I was directed to contact, was very helpful in walking me through your software. Vince was very patient with me even though I am a very small customer in your scheme of things. You have a courteous and patient tech support professional in Mr Vince Murdoch. I needed his help even though I have been doing bulk mailing for 25 years.
K.V., , Pittsburgh, PA