OT : paging the computeristi softwarey types....

If a person had for example around 3000 jpg files, all called
fredbloggs.jpg, junebloggs.jpg etc.

And wanted to change them to SITE1FB1.jpg SITE1JB1.jpg

How would one go about doing this ?

I have the list of names in rows in an excel spreadsheet column1 being
what they are now and column2 being what they should be.

Is there a quick and easy way ?

 

I've used http://www.rlvision.com/flashren/about.asp in the past,
think it will do what you want.

 

You could jfgi -
http://www.labnol.org/software/tutorials/rename-multiple-files-bulk-excel-googl-docs/2481/

 

I asked a similar question on here about 3 years ago and Dan White
suggested

http://www.alatar.de/projects/renamefiles/index.html

I don't know if it will meet your needs exactly (I don't have time to
look) but it was highly effective and did exactly what I wanted.

 

Save the excel spreadsheet as a csv file called 'list',

You can do this in a couple of steps in vi to make the lines in the csv
file read:

mv (or in windows "rename") oldfilename newfilename

then run list as a shell script

# sh list

(or just run list in a windows command prompt)

 

I'd go a bit fancier and pass it through awk, to be re-usable

 

Ta all.

 

Hes right! Place the cursor at the top left and press <esc> then m then a
move to the bottom left <esc> then m then b
You now have two places marked in the file.
Now press <esc> then : and on the vim command line type
'a,'bs/^/mv /
this substitutes the start of the line from mark a to mark b with mv and
a space. Repeat the process to remove commas, make it executable, stick a
shebang at the top and Robert is your mothers brother.

Unfortunately however this is of no use to someone with an excel related
problem.

 

I'm assuming you don't know how to turn the spreadsheet into a batch file
(otherwise you wouldn't have asked).

Send it to me and I'll do it for you.