Page 1 of 1

Export from Command window With Certain Fields

Posted: Thu Jan 12, 2012 1:11 pm
by Kristen
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

Posted: Tue Jun 17, 2014 10:53 am
by Eric
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