massive amount of numbered pdfs-need renamed

[Caitsith]

I have over 6,000 pdfs that have a date and the number of the pdf. For example:

March_15_2011_00001.pdf
March_14_2011_00002.pdf

The numbers go up and I need to get rid of them while keeping the dates. Is there a way to do this with excel?

Thanks!

[delforum]

It appears you want a macro that of some sort, that accesses Explorer, finds a file with trailing numbers, and cuts them off.

I think your question should be moved to the Programming forum, as this requires code to accomplish.

External Link Provides a similar solution of how to do this in VBA....it could be adapted to your purposes for renaming files in excel.

External Link 2 A much more elegant approach taken here to get the directory list.

External Link 3 Straighforward approach of using command line to get file names from dir listing, putting them in excel in one column, and using functions to get the desired output names. Then another command line batch is made using the ren command to use the changes you made in excel.

The excel processing you could use, is paste the filenames you got from the command line in Column A. Then copy these to column B. Do a find/replace in column B to

External Link 4 also at our very own forum On ExcelForum.com Data >> Text to Columns Data Text to columns to split information using the delimited character _ Use command line to run the renaming.