rename 5000 pdf files

September 14, 2010 at 19:35:59
Specs: Windows 7, quad core
have 5000 files in C:\client have an access database with client ID and the path of file associated with client ID. need to rename the PDF files by their client ID. So if the current pdf filename is
20091021_233223.pdf and the client ID is 12345678, the new name should be 12345678.pdf.
any help appreciated/

See More: rename 5000 pdf files

Report •


#1
September 15, 2010 at 13:01:00
Are you able to export the data from your Access DB to a csv including the current filename and the client ID?

With that in hand, it'd be pretty easy to write something to rename the files.



Report •

#2
September 15, 2010 at 13:59:28
I can export them to CSV, tried couple of methods, even used a application that supposedly should do this like a breeze, but no luck. So, if you know of a way the has worked before, I greatly apprecite it if you share!

Report •

#3
September 15, 2010 at 14:05:45
If you can export to a csv, can you provide an example of what the export looks like? From there, we can write something to go through and rename all the files

Report •
Related Solutions


Ask Question