Big CSV file Spliter

# variable used to store the path of the source CSV file

#1) Change line 3 to suit the file path for your CSV file.

# $filepath = "S:\AMS_IT\Application support\jdedwards\fspallocation\lighthouse energy Limited FSP Allocation- Wells.csv "

#2) Change the value for "MaxLines", which are the maximum number of lines in each output file. Preferably, MaxLines < 5000. $filepath = "c:\_staging\==20180430_supercharged energy\supercharged energy FSP allocation-indeserve.csv"
$file = Get-item $filepath
$content = Get-content $file
$csvheader = $content [0]
$lines = $content. Count
$MaxLines = 4000
$filepart = 1
$start = 1
Write-output "Test1"
Write-output "header:" $csvheader;
Write-output "lines:" $lines;
while ($start-lt $lines-1) {
#Set minimum $end value (last line)
if ($start + $minlines-le $lines-1) {$end = $start + $MaxLines-1} else {$end = $lines-1}
Write-output "End:" $end;

#Create New Csv-part
$filename = $file. Fullname.replace ($file. BaseName, ($file. BaseName + ". Part$filepart"))
@ ($content [$start: $end]) | Set-content $filename-encoding ' UTF8 '
#Fix counters
$filepart + +
$start = $end + 1
Write-output "Filepart:" $filepart;
Write-output "Start:" $start;
}
Pause