Need help writing a script/batch file

I have a list of files that correspond to files I need to run a script against.

The list looks like this:
1111
2222
3333
4444
5555
etc...all the values are numerical.

These go to a bunch of files in 'pairs' with -in and -out at the end of the 1111,2222,etc.

I want to write a script that will take that list, pass it to a command
sox -m %1-in.wav %1-out.wav %1.wav

So it would run
sox -m 1111-in.wav 1111-out.wav 1111.wav
then
sox -m 2222-in.wav 2222-out.wav 2222.wav
Until it reaches the end of the list.

I don't know scripting, but I am sure this might be easy to someone who does.
LVL 2
mvalpredaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewCommented:
This should do what you asked:

@echo off
setlocal

set List=1111,2222,3333,4444,5555,6666

for %%A in (%List%) do (
  sox -m %%A-in.wav %%A-out.wav %%A.wav
)

Open in new window

~bp
0
mvalpredaAuthor Commented:
Can I set that list to a file with that info?

I have 30,000 of those entries per directory and probably 40 directories.
0
Bill PrewCommented:
Yes, here is an example of reading the file names from a text file.

If you wanted to automate that further you could have one file that lists the directories to process, and then in each file read the list file to process the individual files.  Of course the list files in each folder would need to have the same name.

@echo off
setlocal

set ListFile=c:\temp\list.txt

for /f "usebackq tokens=1" %%A in ("%ListFile%") do (
  sox -m %%A-in.wav %%A-out.wav %%A.wav
)

Open in new window

~bp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

mvalpredaAuthor Commented:
I was going to do a dir /b and dump that to a text file and clean it up without the -in and -out files. If there is a way to automate that, I am all for it. :)
0
Bill PrewCommented:
I'm sure we can take a lot of the work out of this.  I just need to understand the situation a bit more.

Can you describe the folders and files that need to be processed a bit more?  Like, is there one master "base folder", and then one level down of subfolders that contain the files?  And do all subfolders in the base need to be processed, or only a selection of them that you need to specify?

Do all the files in each folder need to be processed, or only a subset that you need to specify?

Any thing else that might help?

We might be able to do this with no text files depending on the specifics...

~bp
0
mvalpredaAuthor Commented:
Bunch of folders organized by date. Structure looks like z:\2014\03\04\monitor\ for today. Yesterday would have been z:\2014\03\03\monitor\.

I don't mind running it on each directory as there is only about 30-40 directories that need this done. It is not going to be an ongoing thing, just a bit of a programming glitch that went unchecked for about two months.
0
Bill PrewCommented:
Okay, so will all files in each folder need to be processed?

And, can the "sox" utility take a full path to the files involved?

~bp
0
mvalpredaAuthor Commented:
Just what I needed. Did a little extra work by dumping the directory to a text file and then feeding that file into the little script you wrote.

Programmer has fixed their issue....but I have this just in case. I know it will come in handy again in the future.

Thanks again.
0
Bill PrewCommented:
Welcome, glad that was helpful.

~bp
0
mvalpredaAuthor Commented:
Only thing I changed was removing '@echo off' so I could see how far along it is. A blank screen can be a tad scary. :)
0
Bill PrewCommented:
Understand, depending on the script @echo off can be a good or bad thing.  I often add some ECHO lines in the script to display status info along the way to help keep updated on progress.  But for small ones just removing the @echo off can get the job done.

~bp
0
Bill PrewCommented:
And by the way, thanks for helping push me over the 1,000,000 mark in Windows Batch Scripting!

~bp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Scripting Languages

From novice to tech pro — start learning today.