Get last line of text file.

[thenewa2x]

How do you get the last line of a CSV file with out reading the whole file? The CSV file is tabe delimited.

---------------------------------------

http://www.visualactive.net/

 

[EBGreen]

If it is Tab delimited, then it is by definition not a CSV file. To answer your question however, I don't believe it is possible through native functions.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[thenewa2x]

Ok thx. I found an alternative way but I think its slow:

$last_line = "";

while ( ( $line = fgets( $fp ) ) )
    $last_line = $line;

Anyway to improve this?

---------------------------------------

http://www.visualactive.net/

 

[kenrbnsn]

Use the file() function <

http://www.php.net/file>

to read the whole file into an array.

<?php
$lines = file('youfilenamehere');
$last_line = $lines[count($lines)-1];
?>

Ken

 

[sleipnir214]

I don't like using file() unless I know for a fact that the file is not all that large. Loading a sufficiently large file into memory can cause your script to exceed memory limits and be shut down.

You might use filesize() to figure out how long the file is.

Then you might pick a reasonable number of bytes that no line in the file will exceed, and use fseek() to position the file pointer that reasonable distance back from the end of the file.

Then read to the last line.

You'd at least not have to loop through a long file.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[sleipnir214]

Are you running PHP on a unix-like OS? If so, you might look at the system command [tt]wc[/tt], which can tell you things about your file that might make the above more efficient.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[kenrbnsn]

If you're using UNIX or Linux or any OS that has a UNIX like tail command, then the command

tail -1 yourfilehere

will give you the last line.

Ken

 

[thenewa2x]

thanks guys. i'm sticking to what i have.

---------------------------------------

http://www.visualactive.net/