Member_2_6492660_1
asked on
Need to rename 50,000 MP3 Files best way Help
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all who responded
All suggestions will save me a ton of work.
All suggestions will save me a ton of work.
You're welcome. Happy to help. Good luck with the project. Regards, Joe
To capture the file: dir > file.txt
.... Thinkpads_User