Export a file as tab delimited text without quotes in 5.0

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 a file as tab delimited text without quotes in 5.0

Post by Eric » Wed Dec 20, 2006 9:43 am

To export as tab delimited text without quotes, use:

Code: Select all

copy to c:\test.txt DELIMITED WITH "" WITH CHARACTER TAB
To export as semicolon-delimited text without quotes, use:

Code: Select all

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:

Code: Select all

copy to c:\test.txt FIELDS first,last,company,address,city,st,zip DELIMITED WITH "" WITH CHARACTER TAB
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply