Shell Programming and Scripting

Greetings!

Does anyone know of a utility or a script for renaming files on a UNIX web server? I've seen several of these types of renaming utilities for Windows, but none for UNIX. I have 10,000 files that I need to rename in a several tier (deep) web site directory. I have the original names/new names and directory paths documented in MS Access tables. If I could find a tool that would automate this renaming process... even if I need to enter each file name to find and replace, I would be tres happy.

Any advice?

Thanks!!
~Rachel

Hi Rachael,
You could dump the excel spreadsheet to a csv format and then write a simple shell script like the following to do it. FOr example if your csv file was in the format of:

<oldpath>/<oldfilename>,<newpath>/<newfilename>

You could do something like this (may be syntax errors)

Code:

#!/bin/sh
file=`cat file.txt`
for i in $file
do 
    old=`echo $i | awk -F, '{print $1}'`
    new=`echo $i | awk -F, '{print $2}'`
    echo mv $old $new
done

Rachel, TioTony's suggestion is pretty good. But you should put double-quotes around $old and $new and remove "echo" when you're ready to run this.

Do you know how to export the Access tables into a "CSV" or Tab Delimited file?