I had a large SQL file (73MB) that bogged down evey text editor I had available to me on my Windows machine. I knew I needed a particular line from the text file. So based on a Stackoverflow answer and created a split.ps1 PowerShell script:
$Path = "C:\backup" $InputFile = (Join-Path $Path "backup.sql") $Reader = New-Object System.IO.StreamReader($InputFile) $i = 1 While (($Line = $Reader.ReadLine()) -ne $null) { $OutputFile = $i.ToString() + ".txt" $i++ Add-Content (Join-Path $Path $OutputFile) $Line }
Running the script gave me a file for each line.