DOS Batch file - Copy file based on filename elements

Posted by user1848356 on Stack Overflow See other posts from Stack Overflow or by user1848356
Published on 2012-11-23T19:36:22Z Indexed on 2012/11/26 11:06 UTC
Read the original article Hit count: 144

Filed under:

variables

|

script

|

batch

|

dos

|

filenames

I need to sort alot of files based on their filename. I would like to use a batch file to do it. I do know what I want but I am not sure of the correct syntax.

Example of filenames I work with: (They are all in the same directory originally)

2012_W34_Sales_Store001.pdf  
2012_W34_Sales_Store002.pdf  
2012_W34_Sales_Store003.pdf  

2012_November_Sales_Store001.pdf  
2012_November_Sales_Store002.pdf  
2012_November_Sales_Store003.pdf

I would like to extract the information that are located between the "_" signs and put them into a different variable each time. The lenght of the informations contained between the _ signs will be different everytime.

Example:
var1="2012"
var2="W34" (or November)
var3="Sales"
var4="001"

If I am able to do this, I could then copy the files to the appropriate directory using

move %var1%_%var2%_%var3%_%var4%.pdf z:\%var3%\%var4%\%var1%\%var2%

It would need to loop because I have Store001 to Store050. Also, there are not only Sales report, many others are available.

I hope I am clear.

Please help me realize this batchfile!

© Stack Overflow or respective owner

Related posts about variables

System Expandable-String Environment Variables Can’t Reference User Environment Variables

as seen on Super User - Search for 'Super User'
Hi, I’ve run into a bit of a situation with Windows environment variables. I’ve narrowed it down to what may or may not makes sense and/or possibly be by design. It seems that expandable-string environment variables of the local machine cannot reference environment variables of the current user. For… >>> More
Local variables and instance variables

as seen on Stack Overflow - Search for 'Stack Overflow'
Why is it that instance variables are initialised to default values while local variables aren't? >>> More
Arguments, local variables, and global variables in Python

as seen on Stack Overflow - Search for 'Stack Overflow'
In python, there is no way to differentiate between arguments, local variables, and global variables. The easy way to do so might be have some coding convention such as Global variables start with _ and capital letter arguments end with with _ _Global variable = 10 def hello(x_, y_): z =… >>> More
Arguments, local variables, and global variables coding convention in Python

as seen on Stack Overflow - Search for 'Stack Overflow'
In python, there is no way to differentiate between arguments, local variables, and global variables. The easy way to do so might be have some coding convention such as Global variables start with _ and capital letter arguments end with with _ _Gvariable = 10 def hello(x_, y_): z = x_ + y_ Is… >>> More
Difference between putting variables in header vs putting variables in source

as seen on Stack Overflow - Search for 'Stack Overflow'
Say I declare a header file with a variable: int count; Then in the source file, I want to use count. Do I have to declare it as: extern int count Or can I just use it in my source file? All assuming that I have #include "someheader.h". Or should I just declare it in the source file? What is… >>> More

Related posts about script

Asset Pipeline acting up

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok, so my asset pipeline has suddenly started acting up on my development machine. JS functions that previously worked are now throwing "not a function" errors.. I know I must be doing something wrong. A minute ago the datatables jquery function was working, then it was throwing an error, then it… >>> More
Rendering ASP.NET Script References into the Html Header

as seen on West-Wind - Search for 'West-Wind'
One thing that I’ve come to appreciate in control development in ASP.NET that use JavaScript is the ability to have more control over script and script include placement than ASP.NET provides natively. Specifically in ASP.NET you can use either the ClientScriptManager or ScriptManager to embed scripts… >>> More
How do I configure Tomcat services in Ubuntu?

as seen on Server Fault - Search for 'Server Fault'
I have created a Tomcat script inside the /etc/init.d directory which is #!/bin/bash # description: Tomcat Start Stop Restart # processname: tomcat # chkconfig: 234 20 80 JAVA_HOME=/usr/java/jdk1.6.0_30 export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH export PATH CATALINA_HOME=/usr/tomcat/apache-tomcat-6… >>> More
Avoid richfaces to send back javascript libraries in the ajax responses

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using JSF 1.2 with Richfaces, and for every ajax request, the server is sending back the response, whichi is good, but it also contains all the links to the javascript files. I want to improve the performance so I just want the <body> to be returned, because all the javascript files are… >>> More
Whats the difference between running a shell script as ./script.sh and sh script.sh

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a script that looks like this #!/bin/bash function something() { echo "hello world!!" } something | tee logfile I have set the execute permission on this file and when I try running the file like this $./script.sh it runs perfectly fine, but when I run it on the command line like… >>> More