Re: incrementing numbers

On Mar 12, 8:03 pm, Ted Davis <tda...@xxxxxxx> wrote:
On Wed, 12 Mar 2008 13:23:37 -0700, tcdrake wrote:
On Mar 12, 3:04 pm, Ted Davis <tda...@xxxxxxx> wrote:
On Wed, 12 Mar 2008 12:46:29 -0700, tcdrake wrote:

I have run across something else I would like. I only need certain
files unzipped. I know in winzip I can call a list which has all the
files I want to unzip. The command for this is wzunzip.exe -e -s
20080307-5.zip @list.txt c:\test\105. Any chance you can assist in
adding this feature?

Replace
  dir /b *.zip | awk -fscript_file.awk map_file.txt - > }{.cmd in the
batch file with
  awk -fscript_file.awk map_file.txt filelist > }{.cmd

All the DIR command did was to generate a list of all the .zip files -
if you already have a list of files to process, then that's not needed.
 Good thing I wrote that script so it didn't care where its input came
from.

--
T.E.D. (tda...@xxxxxxx)

TED,
Thanks for the quick reply. I didn't make myself clear. You original
script is great and I really do appreciate it. The only change I need is
adding @list.txt to the end of each zip file. So the original code is...

BEGIN{
       UnZipCommand1= "c:\\progra~1\\winzip\\wzunzip.exe -e -s "
        UnZipCommand2 = " c:\\test\\"

I need to put in @list.txt after the zip name. So somehow getting to look
like this...

BEGIN{
       UnZipCommand1= "c:\\progra~1\\winzip\\wzunzip.exe -e -s
@list.txt"
        UnZipCommand2 = " c:\\test\\"

So the output is 20080311-1.zip @list.txt. This will allow me to only
unzip the files I need out of the zip. Make sense?

The only think that can be unzipped is a zip archive - you want to extract
individual files based on a list.

Change

  UnZipCommand2 = " c:\\test\\"

in the script to

  UnZipCommand2 = " @list.txt c:\\test\\"

--

T.E.D. (tda...@xxxxxxx) MST (Missouri University of Science and Technology)
used to be UMR (University of Missouri - Rolla).

T.E.D,
Thank you for all your assitance with this. I could use a little more
help though. I posted this earlier this morning but thought I would
also respond to this post since you were so helpful.


I have a couple of scripts which for the most part work but I need to
change it up a bit based on new requirments. Here is what is currently
happening.

Get 80 zip files in named yyyymmdd-(location).zip
Unzip each zip to a folder based on location code in zip name.
Rename the files to include yesterdays date.
Zip up files and move to anyother directory based on location code.

All the above works fine if I only get one zip file per location per
day. This is an issue when I get more than one zip file per location.
So if I get 20080323-1.zip and 20080324-1.zip because the code I am
using will just unzip the first one then unzip the second to the same
folder which will over write the first ones before I am able to rename
them.

What I need to do is unzip and rename the files based on the date of
the zip file then zip all of the files into one zip based on
yyyymmdd.zip.

Here is my current code which came with a lot of help from this group
and a forum :)

CODE BELOW


@echo off
cd\
cd po\test\users\test
dir /b *.zip | awk -f C:\test\unzip.awk C:\stores.txt - > C:
\unzip.cmd
The above calls the awk code below
CODE
BEGIN{
UnZipCommand1 = "c:\\progra~1\\winzip\\wzunzip.exe -e -s C:\\po
\\test\\users\\test\\"
UnZipCommand2 = " @list.txt C:\\po\\test\\users\\test\\"
# Making the field separator -, ., or TAB makes it work for both
# the file name and the tab delimited map file.
FS = "[-.\t]"
print "@echo off"


}


{
if( NR == FNR ) {
# The file containing the location map.
Table[ $1 ] = $2
}
else {
# The directory listing on STDIN

# The source is the filename in the DIR listing.
Fname = $0
# The target is the given parent directory followed by the location
# from the map file corresponding to the location number in the
# file name (the second field).
Target = Table[ $2 ]
# It may be desirable to ad a trailing "\\" to the command.
Command = UnZipCommand1 Fname UnZipCommand2 Target
print Command
}



}

Then I run the following to rename the files based on the date, zip
and move to the correct directory.

CODE BELOW


BEGIN{

i=0
timetab(z,time() - 86400)
while (i < 2){
yesterday = time()-(i*86400)
timetab(y,yesterday)
{
while ( (getline < "Stores.txt") > 0)
{
printf("REN c:\\po\test\users\test\\%s\\emp.dbf em%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\gndtndr.dbf td%s%02s%02s.dbf
\n",$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\
\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\gndline.dbf ln%s%02s%02s.dbf
\n",$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\
\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\gnditem.dbf it%s%02s%02s.dbf
\n",$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\
\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\itm.dbf i%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\trans.log t%s%02s%02s.log\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\cit.dbf ci%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\cat.dbf ca%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\gndrevn.dbf gr%s%02s%02s.dbf
\n",$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\
\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\rev.dbf rv%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\gndturn.dbf gt%s%02s%02s.dbf
\n",$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\
\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\tdr.dbf t%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\pro.dbf p%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
printf("REN c:\\po\test\users\test\\%s\\cmp.dbf c%s%02s%02s.dbf\n",
$2,substr(y["YEAR"],3,2),y["MONTH"],y["DAY"]) > "C:\\test\\doit.bat"
i++

}

while ( (getline < "Store.txt") > 0)

printf("c:\\progra~1\\winzip\\wzzip.exe -m -s C:\\po\test\users\test\\
%s\\%s%02s%02s.zip C:\\po\test\users\test\\%s\\*.*\n",
$1 ,z["YEAR"],z["MONTH"],z["DAY"], $1) > "C:\\test\\doit.bat"


}

while ((getline <"Store1.txt") > 0)
printf("XCOPY /s C:\\po\test\users\test\\%s\\*.zip C:\\iFtpSvc\\info\
\users\\download\\test\\%s\\\n",$1,$1) > "C:\\test\\doit.bat"

}


while ((getline <"Store2.txt") > 0)
printf("del C:\\po\test\users\test\\%s\\*.zip\n",$1) > "C:\\test\
\doit.bat"
printf("del C:\\po\test\users\test\\*.zip -w 10\n") > "C:\\test\
\doit.bat"


}

I think one option is to have a piece of code which goes through the
directory and makes a list of all the files. Then use that list to
rename the unzipped files based on the list. I just not sure how to
implement it. Any ideas?
.

Relevant Pages

  • rename based on file name
    ... Unzip each zip to a folder based on location code in zip name. ... Rename the files to include yesterdays date. ... Target = Table ... Command = UnZipCommand1 Fname UnZipCommand2 Target ...
    (comp.lang.awk)
  • Re: incrementing numbers
    ... The command for this is wzunzip.exe -e -s 20080307-5.zip ... thing I wrote that script so it didn't care where its input came from. ... So the original code ... unzip the files I need out of the zip. ...
    (comp.lang.awk)
  • Re: rename based on file name
    ... Unzip each zip to a folder based on location code in zip name. ... Rename the files to include yesterdays date. ... Target = Table ... Command = UnZipCommand1 Fname UnZipCommand2 Target ...
    (comp.lang.awk)
  • Re: incrementing numbers
    ... All the DIR command did was to generate a list of all the .zip files - ... script is great and I really do appreciate it. ... So the original code is... ... unzip the files I need out of the zip. ...
    (comp.lang.awk)
  • Re: Unzipping all through a directory structure?
    ... fully ALL files within a hierarchy of folders with zip files in them? ... Ideally I want to unzip all ... pkzip came with pkunzip i'm sure there's a more up to date version ... Find a command to run in each directory. ...
    (microsoft.public.windowsxp.help_and_support)
Loading