Export from Command window With Certain Fields

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
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Export from Command window With Certain Fields

Post by Kristen » Thu Jan 12, 2012 1:11 pm

To Export from the command window to a TXT Tab Delimited File, create a new Command in AccuZIP by pulling the Edit menu down to Command. Give the command a name in the Save As box and in the Command Statement Syntax box put the following:

Code: Select all

COPY TO "c:\output.txt" TYPE DELIMITED WITH TAB

If you want certain fields exported out you could modify the command to add the fields like the example below:

Code: Select all

COPY TO "c:\output.txt" fields first,last,address,city,st,zip TYPE DELIMITED WITH TAB

Or if you want it to export all fields EXCEPT certain fields you could modify it like the below example:

Code: Select all

COPY TO "c:\output.txt" fields EXCEPT barcode,errno_ TYPE DELIMITED WITH TAB

You can change the path and file name (it is currently set as c:\output.txt) to whatever you want

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

Post by Eric » Tue Jun 17, 2014 10:53 am

COPY TO "C:\Customer Data\output.txt" TYPE DELIMITED WITH CHARACTER |

will export as pipe/quote delimited

COPY TO "C:\Customer Data\output.txt" TYPE DELIMITED WITH "" WITH CHARACTER |

will remove the quotes
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply