Help Needed with Searching File/Folder/Move .Bat file

New and improved code.
If your text files are named as the artist and the way you want the subfolder to read then use this

Code:

@echo off

for /f "tokens=1,2 delims=." %%i in ('dir /b C:\Artist\*.txt') do (call :COPY_FILES "C:\Artist\%%i.%%j" ".\%%i\*.*")

exit

:COPY_FILES
for /F "usebackq delims==" %%G in (%1) do xcopy /qv "%%Glyricschords.*" %2

No need to create a line for each artist it uses the text files name as the artist name.
I've only given code to copy the files to subfolders because it's easier than the move command.

BTW the text files should be located in C:\Artist and again run this from the folder containing the files to copy. This is based on your list formatted as

fortyhourweek
hatsoff
hangingupmytravelingshoes

if they are like

fortyhourweeklyricschords.html
hatsofflyricschords.html
hangingupmytravelingshoeslyricschords.html

then replace "%%Glyricschords.*" with "%%G"
with this code all list will need to be in the same format.

I could see why that would be handy. Just change the last line to this

for /F "usebackq delims==" %%G in (%1) do xcopy /qv "%%Glyricschords.*" %2 && del /q /f "%%Glyricschords.*"

bit of info on &&

Use to run the command following && only if the command preceding the symbol is successful. Cmd.exe runs the first command, and then runs the second command only if the first command completed successfully.

Sorry for the late reply but it took a little to get something I think will work, well it's the best I can come up with anyway. It's still a hassle and also a 2 stage approach.

Create a folder and put the 0Songs2Organize.txt and the FindReplace.vbs script in it. A sample batch file and the VBScript are attached.

VBScript came from - VBScript Search and Replace

Create a batch file with the following code or start with my sample.

Code:

set STRING=
findstr /i /c:"%STRING%" ".\0Songs2Organize.txt"> ".\Artist\### %STRING%.txt"
findstr /i /v /c:"%STRING%" ".\0Songs2Organize.txt"> 0Songs2Organize1.txt
del ".\0Songs2Organize.txt"
ren ".\0Songs2Organize1.txt" "0Songs2Organize.txt"
cscript FindReplace.vbs ".\Artist\### %STRING%.txt" "%STRING%" ""
cscript FindReplace.vbs ".\Artist\### %STRING%.txt" " " ""

Now to use this you need to open 0Songs2Organize.txt and copy "by Artist Name" or "Artist Name" for the ones that don't have "by" in front and paste to the batch file so it looks like, set STRING=by Artist Name

If the "by Artist Name" has the "&" char in it, like "by carl & pearl butler" then it will need to be put in as, STRING=by carl ^& pearl butler.

You can do several at a time. Each time the batch runs it will remove the line from 0Songs2Organize.txt to make it easier to do the ones you havn't already done.

Don't worry about the Artist.txt filename yet we'll get to that just see how you go with this for now.

To be continued...

Gunslinger2 said:

I'm having to sit and read/search for the artist, song, copy & paste to the corresponding Artist.txt file then remove the "By "Artist"", turn everything to lowercase and remove all the spacing....manually

Here I'm not sure about "turn everything to lowercase".
Are you talking about the text inside the Artist.txt file or do you mean Uppercase each name in the Artist.txt filename?

For the former I think were fine because DOS ignores cases with most things or use a switch to ignore also I couldn't see any uppercase in 0Songs2Organize.txt anyway and for the latter we'll get to that when we continue.

9 hours now on and off I've been working on organizing a Google Doc spreadsheet containing all relevant info to this project.

[URL Removed]

....and still editing it. Should be easier to come up with a game plan to create a .bat file or script to organize everything with all the information in one place.

Ok. If you get into it again at a later date just continue this thread if you would like more help.

If you want to organize artist with songs via spreadsheet I recommend downloading OpenOffice and save regularly creating a backup each time you save so you always have a 2nd copy if the 1st gets corrupted.

OpenOffice spreadsheet app is called Calc.