Batch Script to move files conditionally to subfolder in same directory

For a .bat version, make file MoveCSV.bat:

set maindir=%1
set tgtdir=%2
move /y "%maindir%\???.csv" "%tgtdir%"

Select allOpen in new window

Run in a CMD window:

MoveCSV "c:\maindir" "c:\targetdir"

Select allOpen in new window

Are duplicates on the target a concern?

No, I have to tell the program to export the data this way, and the next time it exports it will make a directory based on the name of the file I am exporting before it breaks it off. However, I am looking for some conditions to be met to determine which folder to move the file to

This moves all CSVs in a given dir to target dir

@echo off
set maindir=%1
set tgtdir=%2
for %%a in (%maindir%\???.csv) do (
  if exist "%tgtdir%\%%~na\*" (
    move "%%~fa" "%tgtdir%\%%~na"
  ) else (
    echo Missing target dir "%tgtdir%\%%~na"
  )
)

Select allOpen in new window

Run in a CMD window:

MoveCSV "c:\maindir" "c:\targetdir"

Select allOpen in new window

Thanks for the help, is there a way to say that if the name of the file falls within a specific range to send it to a specific file?

Please clarify via an example

The 3 digit numbers refer to first 3 digits of zip codes and I want to separate them by region, so any file named 005.csv (005 coincides with New Jersey), I want to go to my Northeast directory. If the file were named 901.csv (Los Angeles) I want it to go to my West directory.

If you have a comma-delimited .txt file which contains the zip code and State pairs, that should work. e.g. If you have a file Regions.txt

005,New Jersey
901,Los Angeles

Select allOpen in new window

I'd need to revise the .bat code accordingly. Would that work for you?

I don't know how that would work. I have different csv files name with different 3 digit combinations. Are you saying that I would need to create a text file for the .bat to read from to determine which directory to move the csv file to?

> I would need to create a text file for the .bat to read from to determine which directory to move the csv file to?
Yes. I assume that would be a one-time thing since the values would not change. Or, would they?

Still, you'd need some kind of database which shows the relations. Especially if there are lots of them.

The values would not change, at least not very often at some point I might want to move a city to a different directory/region

How many do you have?

Actually, Regions.txt needs to be something like this:

005,Northeast 
901,West

Select allOpen in new window

This works:

@echo off
setlocal enabledelayedexpansion

set maindir=%1
set tgtdir=%2
for %%a in (%maindir%\???.csv) do (
  REM echo "%%~na,"
  for /f "tokens=1-3 delims=," %%A in ('findstr /c:"%%~na," regions.txt') do (
    if [!errorlevel!] equ [0] (
      REM echo %%A,%%B,%%C
      if exist "%tgtdir%\%%C\*" (
        echo move "%%~fa" "%tgtdir%\%%C"
        move "%%~fa" "%tgtdir%\%%C">nul
      ) else (
        echo Missing target dir "%tgtdir%\%%~na"
      )
    )
  )
)

Select allOpen in new window

Not really sure how many there are, I guess there could be up to 1000 different file names split to 4 or 5 different regions.

Then you'll need some sort of database, similar to the Regions.txt example.
I don't have that info.

So it needs to be compiled separately. Maybe google luck will land you such a file. Or, you can make it yourself. At this point, I don't have that time right now.

I appreciate all the help.

Need some clarification here... Your prior comment says:
The 3 digit numbers refer to first 3 digits of zip codes and I want to separate them by region, so any file named 005.csv (005 coincides with New Jersey)

...Which doesn't match the first 3 digits of each NJ here - at least I couldn't find a match: http://www.aip2.com/njzip1.htm

I don't know how accurate the numbers are in that link.

BTW, all the states are here: http://www.paweb2.com/zip.htm

@Ryan

Do your regions relate to some industry standard or is this strictly an internal (to your company) assignment?

The 005 code is associated with the USPS NDC for New Jersey there is a list of the 3 digit codes and which NFC mail goes to on the USPS website.

associating with NJ isn't the issue.  You want to associate with some region.

It is a internal thing

Then, you'll need to get a list/table/key:value source of these associations.  I think that is what the other experts have been trying to communicate with you in this thread.

You can also use FolderAgent without writing any scripts etc.
www.folderagent.com/help/windows_service.html

Shaun... How does your solution handle the zip code issue?

NVIT.... you had this code above...

@echo off
setlocal enabledelayedexpansion

set maindir=%1
set tgtdir=%2
for %%a in (%maindir%\???.csv) do (
  REM echo "%%~na,"
  for /f "tokens=1-3 delims=," %%A in ('findstr /c:"%%~na," regions.txt') do (
    if [!errorlevel!] equ [0] (
      REM echo %%A,%%B,%%C
      if exist "%tgtdir%\%%C\*" (
        echo move "%%~fa" "%tgtdir%\%%C"
        move "%%~fa" "%tgtdir%\%%C">nul
      ) else (
        echo Missing target dir "%tgtdir%\%%~na"
      )
    )
  )
)

What do I need to do to be able to use this. I am new to this and want to make I understand what I am doing so if I need to modify I am able to do that.

Attached is the regions.txt I created.
regions.txt

@NVIT: The start of the filename

@Shaun.
...and how does it handle the associated region issue?

With a lookup, same as ID: 42093768
Can even extend it with a few lines of Powershell instead of writing the whole thing from scratch. It runs as a service so you don't need to schedule scripts etc.