Re: move files based on a spread*** list?


"shdsofblu" <shdsofblu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:88F454C5-26CD-4F61-BE6F-3ABD4E77033A@xxxxxxxxxxxxxxxx


"Pegasus (MVP)" wrote:

Yes, there is.

[In case you also want to know HOW to do it, you should
post two or three sample cells from your spread***.]




The spread*** lists files like so:

zp418.jpg
zp418t.jpg
00021t.jpg

You could do it like so:
1. Save your list of file names as a DOS text file.
2. Create a batch file with the following lines:
#@echo off
#set Source=d:\My Old Files
#set Target=d:\My New Files
#set FileList=d:\Files.lst
#echo.
#
#if not exist "%Source%" echo Source folder "%Source%" not found & goto Exit
#if not exist "%FileList%" echo File list "%FileList%" not found & goto Exit
#if not exist "%Target%" md "%Target%"
#
#for /F "delims=" %%a in ('type "%FileList%"') do echo move "%Source%\%%a"
"%Target%"
#
#:Exit
#echo.
#echo press the Space Bar to close this window.
#pause > nul
Do not retype them - use copy & paste, then remove the #
symbols. Their only purpose is to mark the beginning of each
line.
3. Adjust the batch file to suit your environment, then save it.
4. Run the batch file and check if it does the right thing.
5. Remove the word "echo" to the left of the "move" command
in order to activate the batch file.


.