HI All,

I have to rename a filename as below in win xp dos mode.

actuall files i receive

sample_2008_01_02.csv
sample_2008_02_02.csv

i need to rename them as

sample_20080102.csv
sample_20080202.csv

I have tried like FOR %V IN ('dir c:\a\*.csv') DO FOR /F "tokens=1-5 delims=-" %J IN ('dir c:\a\*.csv') DO Rename "%V" %J%K%L

but i am getting a error file doesnot exsir...if i am trying the same with echo then i can see the file name is changing as per my requirement

FOR %V IN ('dir/b/a-d/o-d c:\a\*.csv') DO FOR /F "tokens=1-5 delims=-" %J IN ('dir/b/a-d/o-d c:\a\*.csv') DO echo Rename "%V" %J%K%L

Please suggest me how can rename the files.pls it's very urgent.

Thanks for your help

-Sandhya

Call me crazy; I don't see any - in filenames.

Untested:

::========================
@echo off
setLocal EnableDelayedExpansion

pushd c:\a

for /f "tokens=* delims= " %%a in ('dir/b/a-d') do (
for /f "tokens=1-4 delims=_" %%i in (%%a) do (
echo ren %%a %%i_%%j%%k%%l
)
)

=====================================
If at first you don't succeed, you're about average.

M2

HI,

Thanks for the code i have tried it but it is not renaming the file is showing %j%%k%%l as filename

-Sandhya

Try this. As written it 'previews' what is to be done. Qhen you're satisfied, remove the ECHO before the REN.

::============================

::========================
@echo off
setLocal EnableDelayedExpansion
pushd c:\a
for /f "tokens=* delims= " %%a in ('dir/b/a-d *.csv') do (
for /f "tokens=1-4 delims=_" %%i in ('echo %%a') do (
echo ren %%a %%i_%%j%%k%%l
)
)

=====================================
If at first you don't succeed, you're about average.

M2

Report Offensive Follow Up For Removal