Standardizing filenames based on a list of names and accounts.

CountDerp

New Member
Joined
Jun 28, 2012
Messages
1
I need to standardize filenames and also add account numbers to the end of each name.
Currently, there are 20 directories, with pdf files in each directory. The names are currently in the form of "Lastname, Firstname Date.pdf", such as "Smith, John 100112.pdf". However, these vary in several ways. The name portion can vary by "Smith, John", "Smith, J.", "Smith J" "Smith,J.". The Date portion is in MMDDYY format, varying by "010112", "01.01.12", and "1.01.2012". Some files have the word "sig" at the end, and they are not to be renamed (e.g. "Smith, J. 010112 sig.pdf". I'm figuring on standardizing these to "Smith, J. 101012", but if there's a better idea then I'm open to it.

Now, on top of standardizing these, I need to append the account number to the end of the filename, so it would show "Smith, J. 010112_1111.pdf". There is a table of names in a spreadsheet, with Account in the A column, Lastname in B, Firstname in C.
Any ideas on what I can do here?
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

b.downey

Active Member
Joined
Oct 16, 2011
Messages
484
Are you looking to automate the renaming of the files to a standard, or are you looking to define a naming standard?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,122
Messages
5,599,826
Members
414,341
Latest member
Mohammedsobhey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top