Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Need to rename 50,000 MP3 Files best way Help

Avatar of Thomas Grassi
Thomas GrassiFlag for United States of America asked on
Shell ScriptingPowershellWindows 7
6 Comments1 Solution831 ViewsLast Modified:
I have over 50,000 .MP3 files on my USB drive and then number is growing.
Building a SQL database to catalog on the files.

I am trying to cleanup the file names.

I would like them to be this format.

01-AlbumName-SongName.mp3

currently they are
01-Songname.mp3
01 - Songname.mp3
songname.mp3

Been doing a lot of copy and paste, I just copy the album name from the folder name and paste it between two - - then delete spaces etc.  Lots of work

I know of how to rename multiple files using F2 in explorer but that does not give me the results I need.

Would be nice like in excel where you can do a find and replace.

No such option in explorer

Looked at third party apps and they are geared toward photo renaming.

I did see one article saying that in Powershell you can do more but not to familiar with powershell.

Any one have an example or idea on how I can do this with out having to click on each and everyone of the files individually.


Thanks Tom
ASKER CERTIFIED SOLUTION
Avatar of Bxoz
BxozFlag of France image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers