Export from Command window With Certain Fields

[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

[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