Shell Programming and Scripting

I have a spreadsheet in a folder that looks like this:
In the same folder I have all necessary folders named as Sector1, Sector2, etc. What I need is to use the first ID listed under Sector1 (SomeID) in the sreadsheet and rename the first file (XXXXX1.JPG) located in folder Sector1 to SomeID. Then go to the second ID (OtherID) and rename the file (XXXXX2.JPG) as OtherID, so on and so forth till all the IDs on that column have been use. After that, go to the next column (Sector2) and rename the first file (xxxx1.jpg) Title, then the second, etc.
Can this be done?

Hi, you could export the spreadsheet as tab delimited ascii file and do something like this

Code:

awk 'NR==1{split($0,S);next}{for (i=1; i<=NF; i++) print "mv",S[i]"/XXXXX"(NR-1),S[i]"/"$i}' infile | sh

It is almost what I need but when I wrote "XXXXX" I was trying to say that the files in the subfolders could have any name such as "Jan 2010 Ana1.jpg" ,"Alberto2.pdf" or "Farewell lunch3.tif". Moreover, if the files have any extension (as .JPG, .PDF or .TIF like in in my example ), the script would not recognize the files and I would get the following output:
If I rename the files to XXXXX1, XXXXX2 and XXXXX3 then everything is fine.
How can I modify your script in such way that it can recognize any file name followed by a number (1,2,3,4,5,6,7,8,9,.....), no matter what extension is present (Party1.jpg, Presentation for tomorrow2.ppt, 454 data3.pdf)
Thanks once again!

Code:

awk 'NR==1{split($0,S);next}{for (i=1; i<=NF; i++) print "mv",S[i]"/*"(NR-1),S[i]"/"$i}' infile | sh

Scrutinizer,

It is great! The only problem is the extension. For instance, imagine that the files I have in folder "Sector1" are the following ones:

A1.doc
B2.doc
C3.doc

If I use your code I get the following:

If I remove the extension

A1
B2
C3

Then everything is great. Would it be possible to modify the script in such way that the file extension is ignore?

Scrutinizer,

I have uploaded the zip file containing all folders and files which I described in my message.
Thanks once again for all your help,

Xterra

Hi Xterra,

One problem is in the first word 'patiente ' in Libro.txt on line 2 and further. This makes the file differ from your original specification. I removed it and then is seemed to work properly.

The other problem is that with the awk code above there is a problem when there is a file called 1 and a file call 11 for example. The * wildcard catches both which is not as intended.

This can be remedied by dropping the * :

Code:

awk 'NR==1{split($0,S);next}{for (i=1; i<=NF; i++) print "mv",S[i]"/"(NR-1),S[i]"/"$i}' infile | sh

S.