Solved

DOS Rename error

Posted on 2006-11-20
15
330 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
  • 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
 
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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction Often we come across situations wherein our batch files would be needing to reboot Windows for a variety of reasons. A few of them would be like: (1) Setup files have been updated whose changes can take effect only after a reboot …
Many people tend to confuse the function of a virus with the one of adware, this misunderstanding of the basic of what each software is and how it operates causes users and organizations to take the wrong security measures that would protect them ag…
This video discusses moving either the default database or any database to a new volume.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now