Export from Command window With Certain Fields
Posted: 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:
If you want certain fields exported out you could modify the command to add the fields like the example below:
Or if you want it to export all fields EXCEPT certain fields you could modify it like the below example:
You can change the path and file name (it is currently set as c:\output.txt) to whatever you want
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