Shell Programming and Scripting

Hi All,

I could use a bit of help with this as I'm at a loss.

I have a number of files all named accordingly:

I have a separate text file that is as follows:

What I want to do is end up with:

I don't know how to do this, though I'm certain it can be done, and would rather learn how than do it all manually. If someone could just point me in the right direction or post the basics so that I could have a starting point I'd much appreciate it.

So far all I've managed to do is replace the ^M from the text file with \r so that cat works properly on it.

System is OS X server, in case it makes a difference.

Thanks.

As best as I can tell (from what I've seen in google results at least) it would be something like the following (yes, I know I'm missing stuff):

ls -ltr | awk '{print $9}'

for $line compare to cat episodes where $line matches cat episodes | awk '{print $2}' mv $line $line-00'{print $3}'.*

That's what I think of anyways. As you can tell I'm missing a bit of the structure, and I have the print 2 and 3 needing input from the second awk, not the first, and I'm unsure of how to get the data from the first added into the second part of it.

Try...

Code:

ls -tr ??????.??? | gawk 'FNR==NR{a[$2]=$3;next}{printf("mv %s %s-%06d.%s\n",$0,$1,a[$1],$2)}' textfile FS="." - | sh

I would leave out the "| sh" at the end until you are happy with the results.

Or something like

Code:

#!/bin/bash
for F in *.*
do	mv $F "${F%.*}-00$(grep ${F%.*} file | cut -d' ' -f3).${F#*.}"
done

I installed gawk, as it's not available by default on OS X, though I didn't notice any difference between running that command with awk vs gawk.

When I run it without the "| sh" I get the following:

Code:

admin$ ls -tr *.* | gawk 'FNR==NR{a[$2]=$3;next}{printf("mv %s %s-%06d.%s\n",$0,$1,a[$1],$2)}' episodes FS="." -

mv bw042810.mp4 bw042810-000000.mp4
...

When I run this (having changed "file" to "episodes" which is the file I showed in my original post) I get the following results:

Code:

bw042810-00.mp4

I appreciate your help, for whatever reason it seems both methods are not getting the input from the episodes file correctly. I've checked but I'm unsure what I should be doing differently do get it to work.

The problem should come from the formatting of the 'episodes' file. Is it Tab, single space or whatever else separated ?