File name manipulation

[elentz]

I have several hundred files that are named in a way that will not work for the way I want to use them. We saved these files with filenames and now we want to change the names. For example the files were named with a 4 digit number. It was an account number for the customer that the file was associated with. Now we use the phone number when we save the file. So now I have several number files in the wrong naming convention. I have a list of the customer phone numbers and the account codes. What I am looking for is some way to rename the files using the list to remove the account number and replace it with the phone number. Can someone suggest a method of accomplishing this?
Thanks

 

[vacunita]

How is this even remotely related with MYSQL?
Even if your list is in a MYSQL DB, all MYSQL can do is return those results it cannot perform file system operations like renaming files.

Perhaps looking at a programming language, that can take your list and go through the folder where you have these files and rename them may be a better choice.

Try:
forum434
forum333
forum855
forum232
forum796
forum102





----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[elentz]

I thought it was a shot in the dark to post here. I thought maybe if I uploaded the files into a table I could use a query to change the names. But, I have to start somewhere. Thanks for the reply I will try some of the avenues you suggested.