Export as tab delimited text with a header

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Export as tab delimited text with a header

Post by Eric » Tue Sep 14, 2010 11:49 am

Use this command to export your data as a tab separated text file with a header record:

Code: Select all

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
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply