Solved

DOS Rename error

Posted on 2006-11-20
15
335 Views
Last Modified: 2012-06-27
Hi,

I have a batch file that executes some SQL statements on a text file and then renames the file with the date...
from SL1.dat to SL12006-11-19.bak

my problem is that it doesn't rename the file with the Date... only renames it to SL1.bak

here's the dos code:

FOR /F "TOKENS=2-4 DELIMS=/ " %%F IN ('DATE /T') DO (SET TODAY=%%F%%G%%H)
REN SL1.dat SL1%TODAY%.bak

is there an error in the code? does it matter if I'm on XP and it was originally written on 2000?
what should I correct?

Thanks! I'm on a deadline... thanks!
0
Comment
Question by:MetDia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 4
15 Comments
 
LVL 67

Accepted Solution

by:
sirbounty earned 250 total points
ID: 17980062
Why not change it to:

ren SL1.dat sl1%date:~0,2%%date:~3,2%%date:~-4,4%.bak
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 17980075
if that fails for you - please post the results by modifying the above to:

FOR /F "TOKENS=2-4 DELIMS=/ " %%F IN ('DATE /T') DO (SET TODAY=%%F%%G%%H)
echo %today%
pause
REN SL1.dat SL1%TODAY%.bak
0
 

Author Comment

by:MetDia
ID: 17980134
this statement works:

ren SL1.dat sl1%date:~0,2%%date:~3,2%%date:~-4,4%.bak

but it is giving me this:
sl1206-1-20.bak

instead of this:
sl12006-11-20.bak

is there a small error in the statement?


the other statement:
FOR /F "TOKENS=2-4 DELIMS=/ " %%F IN ('DATE /T') DO (SET TODAY=%%F%%G%%H)
echo %today%
pause
REN SL1.dat SL1%TODAY%.bak

does not work and doesn't rename the file properly...
the only error message is "ECHO deactivated"


I'd wrather use the first statement because it looks more simple but just need to fix the date...
0
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 
LVL 3

Expert Comment

by:JRockSolid
ID: 17980291
Try this :

ren SL1.dat SL1%date:~4,2%-%date:~7,2%-%date:~10,12%.bak
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 17980321
Try this from a command prompt:

echo %date%
and post the results...
0
 
LVL 3

Assisted Solution

by:JRockSolid
JRockSolid earned 250 total points
ID: 17980340
Sorry i messed up  :

SL1%date:~4,2%-%date:~7,2%-%date:~10,12%.bak  gives you
SL111-20-2006.bak

SL1%date:~10,12%-%date:~4,2%-%date:~7,2%.bak  gives you
SL12006-11-20.bak
0
 

Author Comment

by:MetDia
ID: 17980384
doesn't rename it correctly either...
it gives me SL1-1--2-.bak now...

I tried playing with the different values until I stopped on:
ren SL1.dat SL1%date:~0,10%.bak

and it works perfectly!
Thank you very much JRockSold!
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 17980410
I would've thought I'd have at least gotten an assist here...
0
 

Author Comment

by:MetDia
ID: 17980436
so sorry sirbounty... I have no clue how to give an assist...
is there a way I can change that?
0
 
LVL 3

Expert Comment

by:JRockSolid
ID: 17980515
Yes an assist was defanately in order
Pleasse ask the moderators to help you change it
0
 
LVL 3

Expert Comment

by:JRockSolid
ID: 17980527
Community Support / Customer Service is here:
http://www.experts-exchange.com/Community_Support/
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 17980587
Cool - thanx.
0
 

Author Comment

by:MetDia
ID: 17981076
Thanks guys!!
Won't do that error again!

0
 
LVL 3

Expert Comment

by:JRockSolid
ID: 17981211
Thank you MetDia
and you as well sir
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Occasionally Windows/Microsoft Updates will fail to update. We have found a code that will delete all temporary files and re-register all dll's related to Windows/Microsoft Updates! This works 99% of the time to get the updates working again! The…
Just about everyone has an old PC laying around.  Ask anyone in the IT industry, whether they are a professional or play in it as a hobby.  From outdated Desktops to cheap "throwaway" laptops, they are all around and not as hard to "fix up" as you m…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

728 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