Rename files based on creation date / time

[Apex]

Am trying to figure out if it is possible to batch script the renaming of a bunch of files based on their creation date / time

eg

c:\temp\

file.tmp
file(1).tmp
file(2).tmp
file(3).tmp
file(4).tmp

rename them to

file_01_01_2013.tmp
file_02_01_2013.tmp
file_03_01_2013.tmp
file_04_01_2013.tmp
file_05_01_2013.tmp

and if needs be stick the time stamp in there too

The issue we have is the current rename batch script runs once a week on a Friday to copy the files to a remote system / share but it can not handle it if the file name used is already the remote location; because the rename function in the script just seems to be renaming all the sources files with that days date [the date the batch script ran] - so in effect it isn't doing what it should be

any ideas ?

[DanceswithUnix]

Can you install software on the machine that needs to do this?

Life is too short to waste on trying to get batch scripts to work. Python, Ruby or Bash would be the usual things to try. They are a useful skill to have too, also very nice on a CV

[bytejunkie]

show me the line that renames it to the date the batch file ran and i'll show you a line that renames it to date it was created if its feasible.

you dont say what language its in, so make sure you tell us that.

[TheAnimus]

powershell would make this easier? Is that an option?

[Apex]

Set DD=%DATE:~0,2%
Set MM=%DATE:~3,2%
Set YYYY=%DATE:~6,4%
Set DDMMYYY=%DD%%MM%%YYYY%

#Rename d:\leeds_backup\leeds_full.nbf leeds_full_%DD%-%MM%-%YYYY%.nbf - not used anymore but left in the wscript
Rename d:\leeds_backup\leeds_diff(*).nbf leeds_diff_%DD%-%MM%-%YYYY%.nbf
Copy D:\Leeds_Backup\leeds_diff_*.nbf \\remote server\ITDept\Leeds_NTI_Backup\
Move D:\Leeds_Backup\leeds_diff_*.nbf D:\copied_backup\
d:\postie\postie -host:<mailserver> -to:<emailadderss> -from:<remote server> -s:"description/subject" -nomsg

Business info removed

Nothing new can be installed on this; the business users will not allow it currently.

There is a i think a plan in place to replace the current setup but till then we have to make the best use of the tools we have

[fedya]

powershell would make this easier? Is that an option?

yes we can use it however a BatchRenameFiles Tool could also be an option. Regards, Fedya