Export database name with YYMMMM added to the name

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
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Export database name with YYMMMM added to the name

Post by Eric » Wed Mar 30, 2011 1:45 pm

After exporting a file with the Export Setup window, use this command to rename that exported file. Pull down the Edit menu to Command (or add an Edit > Command event to your script) and run this command:

Code: Select all

copy file "C:\Program Files\AccuZIP6 5.0\Demo\demofile.csv" to "C:\Program Files\AccuZIP6 5.0\Demo\demofile-"+ALLT(STR(YEAR(DATE())))+PADL(ALLT(STR(MONTH(DATE()))),2,"0")+".csv"
In the command, change the path to the full path of the file and location that you're changing. This command assumes you're exporting a csv file.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply