Powershell in Real Life: Fixing an MP3 Album I downloaded

Powershell has some quirks, but all in all is awesome. Here's an example:

Today I downloaded an album from the internet...

PS C:\Users\idvor_000\Downloads\music> dir
    Directory: C:\Users\idvor_000\Downloads\music
Mode                LastWriteTime     Length Name
----                -------------     ------ ----
-a---         1/20/2013  11:47 AM    8648447 01-Loreena_McKennitt-The_Book_Of_Secrets-Prologue.mp3
-a---         1/20/2013  11:48 AM   12194913 02-Loreena_McKennitt-The_Book_Of_Secrets-The_Mummers_Dance.mp3
-a---         1/20/2013  11:47 AM   12026448 03-Loreena_McKennitt-The_Book_Of_Secrets-Skellig.mp3
-a---         1/20/2013  11:49 AM   20341141 05-Loreena_McKennitt-The_Book_Of_Secrets-The_Highwayman.mp3
-a---         1/20/2013  11:49 AM   10037007 06-Loreena_McKennitt-The_Book_Of_Secrets-La_Serenissima (1).mp3
-a---         1/20/2013  11:47 AM   10037007 06-Loreena_McKennitt-The_Book_Of_Secrets-La_Serenissima.mp3
-a---         1/20/2013  11:51 AM   16985204 07-Loreena_McKennitt-The_Book_Of_Secrets-Night_Ride_Across_The_Caucasus.mp3
-a---         1/20/2013  11:50 AM   13847459 08-Loreena_McKennitt-The_Book_Of_Secrets-DantesPrayer.mp3
-a---         1/20/2013  11:48 AM     252931 Loreena_McKennit_The_Book_Of_Secrets.pdf


I have two problems:
  1. I clicked some files twice, and now have duplicate files (La_Serenissima).
  2. The files have the wrong naming convention - I only want the MP3 to be named as the song.
I want to erase the duplicate files. I can find duplicate files by searching for any filename that contains (1), I do this by using the -match operator on each file. The match operator accepts a regular expression thus the funny escaping.
PS C:\Users\idvor_000\Downloads\music> dir | ? { $_ -match "\(1\)"}
    Directory: C:\Users\idvor_000\Downloads\music
Mode                LastWriteTime     Length Name
----                -------------     ------ ----
-a---         1/20/2013  11:49 AM   10037007 06-Loreena_McKennitt-The_Book_Of_Secrets-La_Serenissima (1).mp3
Since my regular expression matches the files I want, I can pass those files to Remove-Item:
 PS C:\Users\idvor_000\Downloads> dir | ? { $_ -match "\(1\)"} | Remove-Item

Next, I want to rename my files to only have the song name. I can do this by splitting the filename on '-', and using the last element. I suspect the following line should work, and test it.
PS C:\Users\idvor_000\Downloads\music> dir | % {echo $_.Name.split('-')[-1]}
Prologue.mp3
The_Mummers_Dance.mp3
Skellig.mp3
The_Highwayman.mp3
La_Serenissima.mp3
Night_Ride_Across_The_Caucasus.mp3
DantesPrayer.mp3

Good that works, now instead of echo'ing lets actually rename the original file to the new name..
PS C:\Users\idvor_000\Downloads\music> dir | % {rename $_  $_.Name.split('-')[-1]}
PS C:\Users\idvor_000\Downloads\music> dir
    Directory: C:\Users\idvor_000\Downloads\music
Mode                LastWriteTime     Length Name
----                -------------     ------ ----
-a---         1/20/2013  11:50 AM   13847459 DantesPrayer.mp3
-a---         1/20/2013  11:47 AM   10037007 La_Serenissima.mp3
-a---         1/20/2013  11:51 AM   16985204 Night_Ride_Across_The_Caucasus.mp3
-a---         1/20/2013  11:47 AM    8648447 Prologue.mp3
-a---         1/20/2013  11:47 AM   12026448 Skellig.mp3
-a---         1/20/2013  11:49 AM   20341141 The_Highwayman.mp3
-a---         1/20/2013  11:48 AM   12194913 The_Mummers_Dance.mp3
Yippy Skippy it works! Happy powershelling.

Comments

Post a Comment

Popular posts from this blog

Finding CLR exceptions without visual studio

(If you want to understand what exception code 0xe0434352 is, read this post ) Often exceptions are thrown and caught and you don't see them. You probably know how to debug this in Visual Studio, so let me show you how to do it in cdb. Sample Code: class Program { static void Main(string[] args) { foreach (var x in Enumerable.Range(0,2000)) { Thread.Sleep(TimeSpan.FromSeconds(1)); Console.WriteLine("Hello World"); ThrowAndCatchException(); } } private static void ThrowAndCatchException() { try { throw new NotImplementedException(); } catch(Exception) { } } } Output of the application: Hello World Hello World Hello World Nothing about an exception, but you're sure it's happening behind the covers -- fire up cdb: C:\Program Files\Debugging Tools for Windows (x64)>cdb -pn consoleapplication3.exe <SNIP> ModLoad: 000007fe`f7e90000 000007fe`f7eb4000 C:\Windows\Mi...
Read more

Why do I keep getting exception code e0434352?

If you want to know how to debug CLR exceptions using cdb then read this post . Exception code e0434352 is the exception code used internally by the CLR to represent most exceptions(*). Regardless of if you throw a System.NullReferenceException or a System.ArgumentException in C#, you'll throw a SEH exception e0434352 under the covers. A fun way to validate this theory is to watch what happens to the CLR exceptions settings in cdb. Fire up cdb, and see the state of clr exceptions: 0:000> .shell -ci "sx" findstr clr clr - CLR exception - second-chance break - not handled clrn - CLR notification exception - break - handled .shell: Process exited Now, set the exception handler for exception number e0434352 and recheck the value of the clr exception handler: 0:000> sxe e0434352 0:000> .shell -ci "sx" findstr clr clr - CLR exception - break - not handled clrn - CLR notification exception - break - handled .shell: Process exited Armed with ...
Read more

Powershell script to enable windows to capture localhost traffic in wireshark

If you want to understand why the following scripts work read this post . Otherwise just paste the following into an elevated powershell window: Setup windows networking to allow localhost capturing in wireshark: # Find the network configuration that has the default gateway. $defaultAdapter = Get-WMIObject Win32_NetworkAdapterConfiguration | ? {$_.DefaultIPGateway} if (@($defaultAdapter).Length -ne 1) {throw "You don't have 1 default gateway, your network configuration is not supported" } # Route local IP address via the default gateway route add $defaultAdapter.IPAddress[0] $defaultAdapter.DefaultIPGateway Write-Host "Start capturing on localhost by connecting to $($defaultAdapter.IPAddress[0])" Return windows networking to normal configuration: # Find the network configuration that has the default gateway. $defaultAdapter = Get-WMIObject Win32_NetworkAdapterConfiguration | ? {$_.DefaultIPGateway} if (@($defaultAdapter).Length -ne 1) {throw "Y...
Read more