Need help writing a script/batch file

mvalpreda
mvalpreda used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
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

Author

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.
IT / Software Engineering Consultant
Top Expert 2016
Commented:
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
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

Author

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. :)
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
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

Author

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.
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
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

Author

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.
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
Welcome, glad that was helpful.

~bp

Author

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. :)
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
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
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
And by the way, thanks for helping push me over the 1,000,000 mark in Windows Batch Scripting!

~bp

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial