We help IT Professionals succeed at work.

Build RegExp to change filenames

Rouchie
Rouchie asked
on
Medium Priority
211 Views
Last Modified: 2012-03-14
I have thousands of mp3 files bought from various places.  My folder file list looks something like this:

Mental Project - 6000 (Roman Gertz Shocked Remix).mp3
714225_-_Looks_Good_Original_Mix_456.mp3
01_-_Why_Not_(klang123ltd).mp3
12963_Throw_Your_Hands_Original_Mix.mp3

I have a batch rename EXE but it requires a RegExp to perform the renaming.  Therefore, can anyone provide an expression that does the following:

Replace _-_ with a single space character
Replace _ with a single space character
Replace - with a single space character
Remove any numeric prefix on the filename (but ignore numbers within the file name)

e.g. 714225_-_Looks_Good_Original_Mix_456.mp3 would become
Looks Good Original Mix 456.mp3
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2015
Commented:
You'll need two separate replacements since you have two target replacement values (i.e. space and empty string). For the first set, try:

Find
_-_|_|-

Open in new window


Replace
[one single space]

For the second:

Find
^[0-9]+

Open in new window


Replace
[Leave blank (i.e. no spaces)]
CERTIFIED EXPERT

Author

Commented:
Beautiful - thank you!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.