[workhard]

Hi,

Want to move the files(*.Doc and *.dot) from multiple level of folders to one folder and limit to copy 7,000 files each time?

From:
C:\Temp\CL\a
C:\Temp\CL\b
C:\Temp\CL\c
C:\Temp\DL\a
.....


To:
C:\Destination\


How to write in batch file??


Behind, copy all the latest file (duplication) and filename should not contain(~abc.doc).



Thanks,

[TheOutcaste]

Welcome to TSG!

So you want to move all *.doc and *.dot files that are in any folder/subfolder under C:\Temp to C:\Destination
You don't want to move more than 7000 files at a time.

Are there other files in these folders, say *.txt or *.mp3?
Do you want to delete the folders afterwards if they are empty?
Could there be duplicate file names? If so, how would you want to handle that?

• Overwrite the existing file?
• Rename the 2nd and subsequent files? If so, using what format?
  1. Add a number to the end of the name
  2. Add Copy (x) of to the beginning of the name
  3. Something else

Originally Posted by workhard

Behind, copy all the latest file (duplication) and filename should not contain(~abc.doc).

I'm not clear on just what you mean by this.
Do you mean after the files have been moved to C:\Destination, you want to make a copy of all the files? Where will these copies be placed?
By "not contain ~abc.doc", does that mean files named exactly ~abc.doc are not allowed, or just filenames ending with ~abc.doc.
Example, File~abd.doc is not allowed but ~abcFile.doc is allowed.
Or do you mean that *.doc files cannot contain ~abc anywhere in the filename, so neither of the above would be allowed, and File~abcTest.doc would also not be allowed?
If a file with that name is found, should it just be deleted, or renamed to something else?

Here's a start until we get the details ironed out.
This will move all *.doc and *.dot files from every folder under C:\Temp to C:\Destination. If there is a duplicate name, it will prompt if you want to overwrite. Note that the All choice won't work, you will be prompted for each duplicate.

@Echo Off
SetLocal EnableDelayedExpansion
Set _Source=C:\Temp
Set _Dest=C:\Destination
Set _MaxToMove=7000
If NOT Exist %_Dest% MD %_Dest%
PushD %_Source%
Set _Count=0
For /F "Tokens=* Delims=" %%A in ('Dir /A-D /B /S *.dot *.doc') Do (
  Move /-Y "%%A" "%_Dest%"
  Set /A _Count+=1
  If !_Count!==%_MaxToMove% Echo Have moved !_Count! Files, quiting&Goto _Max
)
:_Max
PopD

[workhard]

Hi,


Great I got that working perfect. However, I want to move those "~abc.doc" (filename start with ~) to "c:\destination\check" folder.

The rest of non word document move to "C:\destination\non-word" folder.

Can you tell me how from your code?



Thanks,

[TheOutcaste]

This will check each file name for both .doc and .dot files to see if it starts with a tilde (~). This file will be included in the count.
If by non-word documents you mean files with extensions other than .doc or .dot, that will get a bit more complicated.
I'm guessing you want the non-word files to be included in the 7000 file limit.

@Echo Off
SetLocal EnableDelayedExpansion
Set _Source=C:\Temp
Set _Dest=C:\Destination
Set _MaxToMove=7000
If NOT Exist %_Dest% MD %_Dest%
If NOT Exist %_Dest%\Check MD %_Dest%\Check
If NOT Exist %_Dest%\non-word MD %_Dest%\non-word
PushD %_Source%
Set _Count=0
For /F "Tokens=* Delims=" %%A in ('Dir /A-D /B /S') Do (
  Set _tname=%%~nA
  Set _text=%%~xA
  Set /A _Count+=1
  Set _Wfile=0
  If /I NOT "!_text!"==".doc" If /I NOT "!_text!"==".dot" Set _WFile=1
  If !_Wfile!==1 (
    Move /-Y "%%A" "%_Dest%\non-word"
  ) Else (
    If "!_tname:~0,1!"=="~" (
      Move /-Y "%%A" "%_Dest%\Check"
    ) Else (
      Move /-Y "%%A" "%_Dest%"
))
If !_Count!==%_MaxToMove% Echo Have moved !_Count! Files, quiting&Goto _Max
)
:_Max
PopD

Note that the batch file cannot be in C:\Temp or any of it's subfolders, or it will also get moved. Which will cause it to fail with a The batch file cannot be found. message.

[workhard]

Hi,

Great and great. I got that work as well. Now, I want to sort the filename which contain *-cl* into the destination\cl\ folder.


Where should I add the code and what code I should add?


Thanks

[TheOutcaste]

Need more information to figure that out.
If the filename contains -cl and also starts with ~ does it get moved to Destination\Check or Destination\cl?
If it contains -cl and is not .doc or .dot, does it go to Destination\non-word or Destination\cl?

Searching a filename for a particular string that occurs anywhere in the name would require using findstr, which will slow this down considerably. It may be faster to use DIR to find those files first. But if you have more than 7000 of those files, nothing else would be processed on the first run.

Sounds like you need to setup a table with all the conditions you want to check for, and the desired result, something like this

             |                    Condition                    |
             |  Does not contain -cl  |      Contains -cl      |
  Extension  |   Starts   |  Starts   |   Starts   |  Starts   |
             |   with ~   | without ~ |   with ~   | without ~ |
Ext is .doc  | Dest\Check |   Dest    | Dest\Check |  Dest\CL  |
Ext is .dot  | Dest\Check |   Dest    | Dest\Check |  Dest\CL  |
Ext is .*    | Dest\Nwrd  | Dest\Nwrd |  Dest\CL   |  Dest\CL  |

[workhard]

Hi,


Easy, as what I started first, get all the "~*" file (with or without cl) into the Destination\check and non word document(with or without cl) will be in destination\non-word folder.

Next, if the filename contain -cl will be in the destination\cl folder and the rest will be in destination folder.

Code:
| Condition |
| Does not contain -cl | Contains -cl |
Extension | Starts | Starts | Starts | Starts |
| with ~ | without ~ | with ~ | without ~ |
Ext is .doc | Dest\Check | Dest | Dest\Check | Dest\CL |
Ext is .dot | Dest\Check | Dest | Dest\Check | Dest\CL |
Ext is .* | Dest\Nwrd | Dest\Nwrd | Dest\Nwrd | Dest\Nwrd |


Thanks,

[TheOutcaste]

The added code is shown in DarkRed and bold. Also added a line to indicate that all files were moved. It's not case sensitive, so both -CL and -cl (or any combination of case) will be found.
This moves all files that are not .doc or .dot to the non-word folder, whether or not they start with ~ or contain -cl. The first file also did not check for ~ on non-word files.

@Echo Off
SetLocal EnableDelayedExpansion
Set _Source=C:\Temp
Set _Dest=C:\Destination
Set _MaxToMove=7000
If NOT Exist %_Dest% MD %_Dest%
If NOT Exist %_Dest%\Check MD %_Dest%\Check
If NOT Exist %_Dest%\non-word MD %_Dest%\non-word
If NOT Exist %_Dest%\CL MD %_Dest%\CL
PushD %_Source%
Set _Count=0
For /F "Tokens=* Delims=" %%A in ('Dir /A-D /B /S') Do (
  Set _tname=%%~nA
  Set _text=%%~xA
  Set /A _Count+=1
  Set _Wfile=0
  If /I NOT "!_text!"==".doc" If /I NOT "!_text!"==".dot" Set _WFile=1
  If !_Wfile!==1 (
    Move /-Y "%%A" "%_Dest%\non-word"
  ) Else (
    If "!_tname:~0,1!"=="~" (
      Move /-Y "%%A" "%_Dest%\Check"
    ) Else (
      Echo %%~nA|Findstr /I /C:"-cl">Nul
      If !ERRORLEVEL!==1 (
       Move /-Y "%%A" "%_Dest%"
      ) Else (
       Move /-Y "%%A" "%_Dest%\CL"
)))
If !_Count!==%_MaxToMove% Echo Have moved !_Count! Files, quiting&Goto _Max
)
Echo Moved !_Count! Files. All Files moved
:_Max
PopD