Renaming files in a batch process

[SQLWilts]

Has anyone done this... I am just kicking ideas around and any input would be appreciated:

I have a number of files that are produced by a batch process every night. There will be > 15 of them, but I do not know exactly how many there will be.

Their names are like:

mycomapny-name.xml.1
mycompany-name.xml.2
mycompany-name.xml.22

etc etc

I need to get to:
mycompany-name1.xml
mycompany-name2.xml
mycompany-name22.xml

I am looking at using something like forfiles or similar. There is no windows scripting host or perl etc on the server - installing these is not an option.

Good old command line batch processing only guys/gals.

Not as straight forward as it looks - any input gratefully received.

 

[smah]

Some of these should get you close
thread779-1584252
thread779-1567132
thread779-1541192
thread779-1523201
thread779-1515548
thread779-1387129

 

[SQLWilts]

smah,
Thanks for your reply.
After some thought (and a walk away for a while) I imitated a "Do/While" loop like this:

REM get count of files
FOR /F %%j in ('dir *.xml.* /A-D-H /B ^| find /C /V ""') DO SET COUNTER=%%j

REM Loop until the count = 0
:loopstart

REN mycompany-name.xml.%COUNTER% mycompany-name%COUNTER%.xml 

SET /a COUNTER=%COUNTER%-1

IF NOT %COUNTER% EQU 0 GOTO LOOPSTART

:LOOPEND

I will have a look at those posts though to see if there is a better way.

Thanks for looking and posting though

 

[smah]

Based on your example data, I would use the "." as the token delimiter, then simply rename by rearranging the tokens.

for /F "tokens=1,2,3 delims=." %%i in ('dir /b *.xml.*') do (
  ren %%i.%%j.%%k %%i%%k.%%j
  )