BAT file to copy files with incremental number in the filename !?

GeneralLee01 · Feb 26, 2023

Good morning all,

It has been over 35 years ago that I was working on BAT files, so I forgot more than I ever knew about those.

I am trying to copy all XLSB files (with different file names that might change day by day) from directory TEST to directory ONEDRIVE

But when the destination file already exists I want to add a number to the filename.

My intention is to run this file on every re-boot.

As an example I used the file FruitList.xlsb and the desired result in the ONEDRIVE directory should be:
First time copying: FruitList.xlsb
Second time copying: FruitList(1).xlsb
Second time copying: FruitList(2).xlsb
et cetera

This is the BAT code I used:

Batch:

@echo off
set Source=D:\Test\*.xlsb
set Destination=D:\OneDrive\
set Filename=*.xlsb
set a=1

:loop
if exist %Destination%\%Filename%(%a%).xlsb set /a a+=1 && goto :loop
copy %Source% %Destination%\%Filename%(%a%).xlsb
@echo on

DIR /B D:\OneDrive\*.xlsb

PAUSE

Below the result:

D:\Test\FruitList.xlsb
1 file(s) copied.

D:\Desktop>DIR /B D:\OneDrive\*.xlsb
FruitList.xlsb
FruitList.xlsb(1).xlsb
FruitList.xlsb(2).xlsb

D:\Desktop>PAUSE
Press any key to continue . . .

As one can see it basically works ok . . . BUT the extention part is not as desired.

All help will be appreciated

Thanks

garlin · Feb 26, 2023

What you need to consider:
- Filenames can include spaces (use delims=|)
- Normally, duplicates begin with (2)
- goto loops break for-loops and if-then statements, use a call routine

This script works for all *.xlsb files found in the Source folder.

Batch:

@echo off
SETLOCAL
set Source=C:\Users\GARLIN\Documents
set Destination=C:\Users\GARLIN\OneDrive

for /f "delims=|" %%f in ('dir /b "%Source%"\*.xlsb') do (
    if not exist "%Destination%\%%f" (
        copy "%Source%\%%f" "%Destination%" > NUL
    ) else (
        set Filename=%%~nf
        set a=2
        call :loop
    )
)

dir /b "%Destination%"\*.xlsb
pause
ENDLOCAL
goto :eof

:loop
if exist "%Destination%\%Filename% (%a%).xlsb" set /a a+=1 && goto :loop
copy "%Source%\%Filename%.xlsb" "%Destination%\%Filename% (%a%).xlsb" > NUL

C:\Users\GARLIN\Documents>Dukes.bat
Test ABC.xlsb
testA.xlsb
testB.xlsb
Press any key to continue . . .

C:\Users\GARLIN\Documents>Dukes.bat
Test ABC (2).xlsb
Test ABC.xlsb
testA (2).xlsb
testA.xlsb
testB (2).xlsb
testB.xlsb
Press any key to continue . . .

C:\Users\GARLIN\Documents>Dukes.bat
Test ABC (2).xlsb
Test ABC (3).xlsb
Test ABC.xlsb
testA (2).xlsb
testA (3).xlsb
testA.xlsb
testB (2).xlsb
testB (3).xlsb
testB.xlsb
Press any key to continue . . .