?
Solved

Need to rename 50,000 MP3 Files best way Help

Posted on 2013-12-23
6
Medium Priority
?
521 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 97

Expert Comment

by:Experienced Member
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 668 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 55

Assisted Solution

by:Joe Winograd, EE MVE 2015&2016
Joe Winograd, EE MVE 2015&2016 earned 668 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 40

Assisted Solution

by:Subsun
Subsun earned 664 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 55

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

Four New Appliances. Same Industry-leading Speeds.

But don't take it from us.  The Firebox M370 is Miercom tested and Miercom approved, outperforming its competitors for stateless and stateful traffic throughput scenarios.  Learn more about the M370, M470, M570 and M670 and find the right solution for your organization today!

Question has a verified solution.

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

A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
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…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
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…
Suggested Courses
Course of the Month9 days, 22 hours left to enroll

762 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