Solved

Need to rename 50,000 MP3 Files best way Help

Posted on 2013-12-23
6
512 Views
Last Modified: 2013-12-23
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
0
Comment
Question by:Thomas Grassi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 95

Expert Comment

by:John Hurst
ID: 39736138
It might be easier to create a text file of the folder(s) containing the files and then working with Excel or UltraEdit (Text Editor with find and replace) and make a new file with old and new names. Add a column with rename in each row. Then you should be able to run the text file.

To capture the file:    dir > file.txt

.... Thinkpads_User
0
 
LVL 6

Accepted Solution

by:
Bxoz earned 167 total points
ID: 39736143
Ant Renamer - is a realy nice app for renaming and it's free !
Have a look
http://www.antp.be/software/renamer/screenshots
0
 
LVL 54

Assisted Solution

by:Joe Winograd, EE MVE 2015&2016
Joe Winograd, EE MVE 2015&2016 earned 167 total points
ID: 39736155
I've used Mp3tag (free!) for other purposes and it has worked very well:
http://www.mp3tag.de/en/index.html

It also has the ability rename files based on the tag info. This is from the Help file:


Menu Convert > Tag - Filename

You can rename files based on the tag and file information with this converter.

The format string defines the format scheme of the new filename and all placeholders in this format string will be replaced with the information from the file when executing this converter.

Format string

The format string describes the filename scheme for the rename operation based on the tag and file information.

You can use the following placeholders:

%album% Album
%artist% Artist
%comment% Comment
%genre% Genre
%title% Title
%track% Track-Number
%_total% Total number of tracks from xx/xx track-number field
%year% Year
%fieldname% Any other tag field not listed here with the name 'fieldname'. Please have a look at 'View > Extended Tags...' for an overview of all available tag fields in your file.

It also has a built-in scripting function that works with the tag-filename converter. Download is here:
http://www.mp3tag.de/en/download.html

Regards, Joe
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 40

Assisted Solution

by:Subsun
Subsun earned 166 total points
ID: 39736167
Try this code and see if you get the expected result..
GCI C:\MP3 -Recurse -Include *.mp3 | % {
$Name = $_.Name -split "-",2
	If (($Name | measure).Count -eq 1){
	Ren $_.Fullname "01-$(($_.DirectoryName -split "\\")[-1])-$($Name[0].Trim())" -WhatIf
	}Else{
	Ren $_.Fullname "$($Name[0].Trim())-$(($_.DirectoryName -split "\\")[-1])-$($Name[1].Trim())" -WhatIf
	}
}

Open in new window

I have added  -WhatIf parameter which will simulate the renaming.... remove -WhatIf and run the code to perform the actual renaming of files..

PS : This is a basic code, I have not added any error control or logging..
0
 
LVL 23

Author Closing Comment

by:Thomas Grassi
ID: 39736222
Thanks to all who responded

All suggestions will save me a ton of work.
0
 
LVL 54

Expert Comment

by:Joe Winograd, EE MVE 2015&2016
ID: 39736263
You're welcome. Happy to help. Good luck with the project. Regards, Joe
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A brief introduction to what I consider to be the best editor for PowerShell.
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question