Couple o php questions

[Mincer]

1) Is there an easy way to strip "'s from a text file using php?

It's not really feasible to do a s/r using a text editor as the files will be uploaded by a user and actioned directly rather than them passing through my control first.


2) How can I read a line at a time from a csv file before exploding it?

Say grab all characters into a string until \n and then process, then repeat in a loop until EOF

(I could do this in c++ - albeit a bit rusty now - but not really sure in php)

Any solutions greatly appreciated.

Matt.

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

If there's no way of easily reading the file a line at a time, is it a really bad idea to read a 1000+ line file in to an array in one go, and then exploding it into lines on \n, and then exploding each line at a time on the delimiter?

Lastly, if I do this, is this a good way of exploding a line at a time until EOF??

PHP Code:


$filename = "file.txt";
$fp = fopen($filename, "r");
$file_contents = fread($fp, filesize($filename));
fclose($fp);

$lines = explode("\n", $file_contents); 

// loop for as long as $lines is not EOF

while($i <= sizeof($lines)) {        

    // explode to get each field from line
    $data = explode(";", $lines[$i]);

    // do some stuff to enter fields into DB

    // increment to continue looping
    $i++;
    
} 


I know that this will work ok for small files, but what would be a cut-off for 'small file' ??

[Mark Hensler]

1) try this:

PHP Code:

$text = str_replace("'s", '', $text); 


2) try this:

PHP Code:

$fd = fopen ("file.txt", "r");
// loop until EOF
while (!feof ($fd)) {
    // read one line, up to 4KB
    $buffer = fgets($fd, 4096);
    
    // explode to get each field from line
    $data = explode(";", $buffer);
    
    // do some stuff to enter fields into DB
    
}
fclose ($fd); 


PHP DOCS: fgets(), fopen(), feof(), str_replace

[Mincer]

Thanks for the quick response.

The first question, I needed to replace the quotation char " with nothing. I guess the principal is the same though. Can I just use \" ??

PHP Code:

$text = str_replace("\"", '', $text); 


EDIT: Yes it is.

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

Secondly, just so I understand correctly... (always a bonus in my case )... fgets() reads one line up to endline?? (nix or win or both??)

Thanks.

[Mincer]

In case anyone cares....

I added:

PHP Code:

$fd = fopen ("data.csv", "r");

// loop until EOF
while (!feof ($fd)) {

    // read one line, up to 4KB
    $buffer = fgets($fd, 4096);
    
    if ($buffer == '') exit();  // 2 single quotes
    else {
    
        // explode to get each field from line
        $data = explode(";", $buffer);

        $data = str_replace("\"", '', $data);
    
        // do some stuff to enter fields into DB
    
    }
    
}

fclose ($fd); 


To stop it outputting garbage if there are empty lines at the end of the file. (in my case empty lines will not occur in the file up till then).

[Mark Hensler]

fgets() will read up to the number of bytes you specify, until it reads a EOL, or until EOF (which ever comes first). PHP is wise to the win/unix differences, and will watch for \n on unix and \r\n on win for EOL.