[SOLVED] delete x lines of a csv

[ThunderAI]

How do you go about deleting the first x number of lines of a CSV. I want the first three or one line deleted.  I could open the file and read the lines, but how do I physicaly delete them so they are not read by the LOAD DATA function.

[sasa]

try

<?php
$fileName = 'test.dat';
$numLine = 3;
$a = preg_replace("/^(.*?\n){0,$numLine}/",'', file_get_contents($fileName));
$b = fopen('test.dat', 'w');
fwrite($b, $a);
fclose($b);
?>

[hitman6003]

<?php

$num_to_remove = 3;

$file = file($filename);

// php5 only
file_put_contents($filename, implode("\n", array_slice($file, $num_to_remove)));

// php4
/*
$open = fopen($filename, 'w');
fwrite($open, implode("\n", array_slice($file, $num_to_remove)));
fclose($open);
*/

[ThunderAI]

First suggestions works 100% correctly.  Second one looks cleaner, but adds an extra line space in between every row.  Is there a way to remove that extra line space?

[hitman6003]

Remove the implode function...

 

file_put_contents($filename, array_slice($file, $num_to_remove));