View Single Post
 
Old 10-16-2021, 10:45 AM
JustJim JustJim is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Oct 2021
Posts: 1
JustJim is on a distinguished road
Default Strip out numbers from file names in a directory.

Greetings,

I have a bunch of Word files in a directory with names like this one:

46468-1448197 - Smith-Bob-Sep 12, 2021 220 PM

The file names have a consistent pattern throughout. Each begins with a hyphenated serial number(?) with the same number of digits, followed by a space, followed by a hyphen, followed by a space. Beats me why the source of these files would name them that way, but that was not my call.

I want to run a macro that truncates the names of all files within a selected directory up to and including the " - ", so that what is left is merely:

Smith-Bob-Sep 12, 2021 220 PM

I looked for and noticed bits and pieces of code that provide a partial solution but I cannot piece it together.

Your kind help is much appreciated.

Jim.
Reply With Quote