I have a series of .wav files with similar file names. Each file has a first and last name followed by the date and a number. I would like to create a series of files based on the first and last name and then move the files to the matching file path.
Example:
John_Doe_1-6-6-2021 15-23_123453245.wav
John_Doe_1-6-6-2021 15-23_12345874.wav
John_Doe_1-6-6-2021 15-23_1239964.wav
Mary_Walker_1-6-6-2021 15-23_123453245.wav
Mary_Walker_1-6-6-2021 15-23_1778941.wav
Mary_Walker_1-6-6-2021 15-23_8741556899.wav
I would like those files to be organized similar to the following:
SourceDirectory
|> John_Doe_1
|> John_Doe_1-6-6-2021 15-23_123453245.wav
|> John_Doe_1-6-6-2021 15-23_12345874.wav
|> John_Doe_1-6-6-2021 15-23_1239964.wav
|> Mary_Walker_1
|> Mary_Walker_1-6-6-2021 15-23_123453245.wav
|> Mary_Walker_1-6-6-2021 15-23_1778941.wav
|> Mary_Walker_1-6-6-2021 15-23_8741556899.wav
At the moment I have this script. The script will create a folder based on the First Name and moves the files there (Which is great), the only issue is I need the first name, last name and the 1 at the end. So the Folder should be like John Doe 1 not just John or John Doe.
@echo off
SETLOCAL
SET "sourcedir=C:\Users\JohnUser\Desktop\Test\"
PUSHD %sourcedir%
FOR /f "tokens=1*" %%a IN (
'dir /b /a-d "* *_*-* *.*"'
) DO (
MD %%a
MOVE "%%a %%b" .\%%a\
)
POPD
GOTO :EOF
pause
Here's a quick example using the - character as the delimiter, Delims, to perform the fiilename string split. (You could use Tokens=1, but as that is the default, I have left it out):
@Echo Off
SetLocal EnableExtensions
Set "SourceDir=%UserProfile%\Desktop\Test"
For /F "Delims=" %%G In (
'%SystemRoot%\System32\where.exe "%SourceDir%":"?*-?*-?*-???? ??-??_?*.wav"'
) Do For /F "Delims=-" %%H In ("%%~nG") Do (
%SystemRoot%\System32\Robocopy.exe "%SourceDir%" "%SourceDir%\%%H" "%%~nxG" /Mov 1>NUL
)
To understand how any command works, open a Command Prompt window, type Command /?. For example for /?, where /?, robocopy /?.