Split up SQL file

Split_up_SQL_file.ps1

$InputFile = 'C:\Input.txt'
$outDir = 'C:\Output'

$inputContent = Get-Content $InputFile

foreach ($line in $inputContent)
{
    if ($line.Length -gt 0)
    {
        $firstChar = $line.Substring(0,1)
        if ($firstChar -ieq 'C')
        {
            $objectName = $line.Substring(30)
            $outFile = $outDir + '\' + $objectName.Substring(0, $objectName.IndexOf("]")) + '.sql'
            $outContent = '--$Rev$' + "`n$line"
            #Write-Host $outContent
            Set-Content -Path $outFile -Value $outContent
        }
    }
}