datetime - Loop through file timestamps, and if it equals to today's date, copy file -


good day all

i have bunch of sql files in folder. loop through each file , timestamp of file. if timestamp mathes current date, want copy file new location.

here directory structure of files:

c:\mfa\mfa_timestamp\mfa_timestamp.sql

and example of file be: 

c:\mfa\mfa_20131008\mfa_20131008.sql

so here code have far, not right...

set currentdate=%date%  /r c:\mfa\ %%g in (*.sql) set %%g=%file%  %%f in (%file%) set filedatetime=%%~tf if %filedatetime:~0, 10% == %currentdate% goto same  goto notsame  :same copy %file% c:\newlocation  goto next  :notsame  goto end  :next

any suggestions on doing wrong here?

thanks

@echo off setlocal enableextensions enabledelayedexpansion  set "currentdate=%date:~0,10%"     %%g in ("c:\mfa\*.sql") (      set "filedate=%%~tg"      set "filedate=!filedate:~0,10!"      if "!filedate!"=="%currentdate%" (         copy "%%~fg" "c:\newlocation"      )     )

for each .sql file in indicated folder, if file date (10 first characters, i'm assuming date in mm/dd/yyyy variation) equal current date (same amount of characters), copy file new directory

edited - seems 2008 server installation gives problems delayedexpansion. under same asumption (from data in op original question), date in mm/dd/yyyy variation, , since file date in filedatetime returned (as far know) in same format in %date% variable, "should" work (i hope, previous code "should" work) without delayedexpansion

@echo off     setlocal enableextensions disabledelayedexpansion      /f %%d in ("%date%") %%a in ("c:\mfa\*.sql") /f %%b in ("%%~ta") (         if "%%b"=="%%d" copy "%%~fa" "c:\newlocation"     )      endlocal

it takes first token of data returned '%date%' , each file in indicated set, take first token in file datetime field , check agains splitted current date. if 2 values equal, file copied target.

edited 2 - well, seems not work in 2008 server. next try. without delayed expansion. far %date% variable returns information in same format file datetime (not sure if can different), , in file datetime date part appears before time part, "maybe" works.

@echo off     setlocal enableextensions disabledelayedexpansion      set "source=d:\descargas\_work\x"     set "target=c:\newlocation"      /f "tokens=2 delims=|" %%a in (         'cmd /q /d /c "for %%f in ("%source%\*.*") echo(%%~tf^|%%~ff"^|findstr /l /i /b /c:"%date%"'     ) (         echo copy "%%a" "%target%"     )

-

Comments

Post a Comment

Popular posts from this blog

html - Sizing a high-res image (~8MB) to display entirely in a small div (circular, diameter 100px) -

first of all, thank being patient know simple question more couple of weeks' experience figure out. i've seen folks persevere , helpful on here , hope you're willing me. here fiddle: http://jsfiddle.net/65uzf/ here 1 of places searched answers on here: ( vertically center image thumbnails fix-sized div ) tried solutions on there , didn't work out me. i've searched ~4 or 5 others, , been unsuccessful those, too. what want take large image (what linked background-image #ysypic , #tabpic divs) , display thumbnail version of image in confines of divs have set it. is, using background properties have laid out in css, portion of image displays inside of circular divs. without these properties, display defaults smaller section of image [presumably pi*(50^2) area in top left] terrible resolution. i not care if entire image doesn't display inside of circles (it won't, given difference in shape), , overflow not being displayed fine. want able see figu
Read more

java - IntelliJ - No such instance method -

using intellij's 12 ultimate, i'm running following code in debugger: java import play.api.libs.json.jsvalue; public class foo { ... public jsvalue tojson() { ... } public class fooexample { ... foo foo = new foo(); system.out.println("...); //<-- breakpoint at breakpoint, right-clicked source code , picked "evaluate expression," typing in: foo.tojson() . but following error showed up: no such instance method: play.api.libs.json.jsvalue$class.com.foo.foo.tojson () am doing wrong? foo#tojson calls scala code, if matters. edit had breakpoint after instantiation of foo. downvoted it, deserved it. edit my answer no longer valid after op modified question (i.e. moved breakpoint actual is).. a breakpoint hit before line executed. in case foo has not yet been declared or instantiated (i.e. foo constructor has not yet been called). you'll need put breakpoint @ next line (or step on current line) if want evaluate foo .
Read more

identifier - Is it possible for an html5 document to have two ids? -

i wondering if html5 element can have 2 ids, this: <button id="thing1" id="thing2" name="button1" onclick="change()">click here</button> or this: <button id="thing1, thing2" name="button1" onclick="change()">click here</button> also, if 1 of ids said 1 thing, , other id said thing, 1 used? tl;dr : no. in versions of html, each element can have 1 id. see the spec : the id attribute specifies element's unique identifier (id). [dom] the value must unique amongst ids in element's home subtree , must contain @ least 1 character. the value must not contain space characters. note: there no other restrictions on form id can take; in particular, ids can consist of digits, start digit, start underscore, consist of punctuation , etc. note: element's unique identifier can used variety of purposes, notably way link specific parts of document usin
Read more