for %f in ( *.ctl ) do set d1=%f echo %d1~1,2%
this gives the last file number, as i cut the file number positioned at 2nd 3rd place.

I want to cut all the file number stratung from 1 and then my aim is to run sqlplus for everyfile.
But this cuts only last file no and sqlplus for all the times.

while using %f:~1,2% it doesn't give desireed results.
If some escape characters have to be used and where please help me with that. I have tried ^ and "" but to no use.

thanks

Do you have "special characters" in the *.ctl filenames?

If so, give examples.

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

Hi
Not quite sure what you want to do, but the code below will echo the 2nd & 3rd character of every filename.

@echo off
setlocal enabledelayedexpansion
for %%f in (*.*) do set d1=%%f & echo !d1:~1,2!