Rename all files in a folder according to pattern

do version 9.0.0.7 on xp sp2 (yes, I know there is a new version but this is the license I currently have on this system)

I have a directory with 936 files that have this kind on filename pattern

SomeThingIsLocatedHere_20100505_2356_2335.xls

The first numeric string is the date and the last four numbers are the hour and minute the file was created.

I need to rename the files in such a way that the middle numeric string "2356_" is removed, so the above would become

SomeThingIsLocatedHere_20100505_2335.xls

There are several variations of the string "2356" but the rule is that any 4 digits between the file date and time is removed.

Any tips?

There's no need to use that three year old version.

If you have a licence valid for 9.0.0.7 then it's also valid for all 9.x.x.x versions, including the current latest (9.5.3.0).

Old name: (.+[0-9]+)[0-9][0-9][0-9][0-9]_([0-9]+.[^.]+)
New name: \1\2
Type: Regular Expressions


thank you

do I first select (CTRL-A) all the 900 plus files or is there a way to make this change without having to mark and select the files?

There are several variations of the SomeThingIsHere but all of the rest of the patterns match in such a way that the filedate is always 8 numbers (year, month, date ie 20100505) and then the 4 numbers I want to remove and then the hour minute (ie 2015)

worked fine, thank you again

Just use Ctrl-A. There are ways to avoid having to select things but there's no reason to use them here.

It won't rename files that don't match the pattern, even if you select them as well.