Powershell version

[therealmichaelberna]

Here's a powershell version that I made that if they are named properly it will add the season and episode, so I wanted to share. Please note, for it to work, the column names must be single words renamed to "Number" "Name" "Aired"

cls
#$CSVPath = Read-Host "Please enter CSV path"
#$directory = Read-Host "Please enter directory path"
$directory = "Z:\Television\Looney Tunes"
cd $directory

$CSVPath = "Z:\Television\Looney Tunes\tvdb.csv"    
"CSV Path: $CSVPath"

$csv = Import-CSV $CSVPath
#$csv | Select-Object Number, Name, Aired | Format-Table

$csv | ForEach-Object{

    $name = $($_.Name)
    $number = $($_.Number)

    Get-ChildItem *$name*|%{
        "Match found for $name"
        "$name info:"
        "number: $number"        

        $pos = $number.IndexOf("x ")
        $episode = [int]$number.Substring($pos+2)
        
        if($episode -lt 10)
        {
            $episode = "0$episode"
        }

        "Episode: $episode"
         
        $fullName = $($_.FullName) 

        "childItemName:  $fullName"
        $containingFolder = Split-Path -Path $fullName
        "Containing Folder: $containingFolder"
        $fileName = Split-Path -Path $fullName -Leaf -Resolve

        "Filename: $fileName"

        $season = $number.substring(0, 4)
        "Season: $season"
        
        $preparedStatement = [Regex]::Escape("Looney Tunes - ")
        $newFileName = $fileName.replace("Looney Tunes - ", "Looney Tunes - "+"s$season"+"e$episode - ")        

        $destFile = $containingFolder + "\Season $season\$newFileName"

        "Dest: $destFile"
        $destFolder = Split-Path -Path $destFile
        "Dest folder: $destFolder"
        
        If(!(test-path $destFolder))
        {
              New-Item -ItemType Directory -Force -Path $destFolder
        }

        Move-Item -Path $fullName -Destination $destFile
    }
}