Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

batch script file to move based on

Posted on 2010-11-19
10
Medium Priority
?
842 Views
Last Modified: 2012-05-10
I need a batch script to move the last file in a folder called "data" but we need to check the last modified time stamp using WMIC we need to go down to miliseconds
WMIC DATAFILE WHERE "PATH='\\Log\\'" GET Name, LastModified, name

Open in new window

0
Comment
Question by:CalmSoul
  • 6
  • 4
10 Comments
 
LVL 59

Expert Comment

by:Bill Prew
ID: 34175965
I think should do what you want.  If it seems to get the correct file then change the ECHO at the end to a MOVE of the file to wherever you want it.

@echo off
for /F "tokens=1*" %%A in ('wmic datafile where "path='\\Log\\'" get LastModified^,Name ^| find /i /v "LastModified" ^| sort') do set LatestFile=%%B
echo %LatestFile%

Open in new window

~bp
0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34176336
where you have mentioned to move to data folder?
0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34176430
how we can move files in batches eg first 100 then next 100 so on...
need to add a FOR loop
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 59

Expert Comment

by:Bill Prew
ID: 34176449
You'll need to be clearer about what you need the script to do please.  I thought you just wanted to find the most recent file, and move it.  But it sounds like you want to move them all, into some groupings by date/time.  Not clear yet though.

~bp
0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34176482
bp:

Basically we have 30,000 files we need to move to different folder oldest first (based on date/time miliseconds) then next oldest and then so on.

I am sorry if we were not clear earlier?
0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34176863
bp: any update we need as soon as possible
0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34185356
bp:

any update?
0
 
LVL 59

Accepted Solution

by:
Bill Prew earned 2000 total points
ID: 34185357
@echo off
setlocal EnableDelayedExpansion
set Count=0
set Group=1
for /F "tokens=*" %%A in ('dir /a-d /b /o-d /tc "c:\source\*.*"') do (
  set /A Count+=1
  if !Count! GTR 20000 (
    set /A Group+=1
    set Count=1
  )
  echo Group:!Group!, Count:!Count!, File:%%A
  move "%%A" "c:\destination\"
)

Open in new window

0
 
LVL 5

Author Comment

by:CalmSoul
ID: 34188609
I  am getting following
C:\Log\New Folder>setlocal EnableDelayedExpansion

C:\Log\New Folder>set Count=0

C:\Log\New Folder>set Group=1

C:\Log\New Folder>for /F "tokens=*" %A in ('dir /a-d /b /o-d /tc "c:\log\*.*"')
do (
set /A Count+=1
 if !Count! GTR 20000 (
set /A Group+=1
 set Count=1
)
 echo Group:!Group!, Count:!Count!, File:%A
 move "%A" "C:\Log\New Folder\New Folder\"
)

C:\Log\New Folder>(
set /A Count+=1
 if !Count! GTR 20000 (
set /A Group+=1
 set Count=1
)
 echo Group:!Group!, Count:!Count!, File:move.bat
 move "move.bat" "C:\Log\New Folder\New Folder\"
)
Group:1, Count:1, File:move.bat
The system cannot find the file specified.

C:\Log\New Folder>(
set /A Count+=1
 if !Count! GTR 20000 (
set /A Group+=1
 set Count=1
)
 echo Group:!Group!, Count:!Count!, File:Log_13-8-2010.txt
 move "Log_13-8-2010.txt" "C:\Log\New Folder\New Folder\"
)
Group:1, Count:2, File:Log_13-8-2010.txt
The system cannot find the file specified.

C:\Log\New Folder>pause
Press any key to continue . . .

Open in new window

0
 
LVL 59

Expert Comment

by:Bill Prew
ID: 34193471
It looks like you saved the BAT script as a file called MOVE.BAT.  That will be a problem, since the MOVE command is a reserved internal command name.  Rename the BAT from from MOVE.BAT to something else like MYMOVE.BAT.

~bp
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Progress
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question