Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Export undeliverables in a script with watch folders

Use this two-line command to export your undeliverables. This command assumes you have the Script Monitor - Write Input Files command as the second event of your script

com_InputFilePath=FILETOSTR("Cleanup.ini")
COPY TO (FORCEEXT(com_InputFilePath,"")+"_undeliverable.dbf") FOR dpv_="N"

To export as comma-delimited text with the field names added as a header record:
 

COPY TO (FORCEEXT(DBF(),"")+"_undeliverable.dbf") FOR dpv_="N" TYPE CSV

To export as comma-delimited text with no header record:
 

COPY TO (FORCEEXT(DBF(),"")+"_undeliverable.dbf") FOR dpv_="N" TYPE DELIMITED

If you want to export specific fields, use this:
 

COPY TO (FORCEEXT(DBF(),"")+"_undeliverable.dbf") FIELDS first,last,zip FOR dpv_="N" TYPE CSV

« Back to Tech Notes

AccuZIP has tremendously improved the postal service our clients receive...not to mention the tremendous postage savings available when a mail ing list is upgraded by AccuZIP.
J.F., Boston, MA