note 47594 added to function.fgetcsv
| From: | Daffy at osu1 dot php dot net | Date: | Mon, 22 Nov 2004 14:25:47 +0000 |
| Subject: | note 47594 added to function.fgetcsv | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-80863@lists.php.net to get a copy of this message | ||
This is a little sniplet for all users who has problems with Excel csv files. This functions does
almost the same like the linux shell program dos2unix.
/* ------------------8<------------------------*/
function dos2unix ($filename) {
//open original file
$fp = fopen($filename,'r');
//open original file
$fptmp = fopen($filename.'_tmp','w');
while(!feof($fp)){
$line = chop(fgets($fp,4096));
$ret = ereg_replace(chr(13) . chr(10),"\n",$line);
$ret = ereg_replace(chr(13),"\n",$ret);
fwrite($fptmp,$ret);
}
fclose($fp);
fclose($fptmp);
//remove original file
unlink($filename);
//move converted file to old filename
copy($filename.'_tmp', $filename);
//remove temp file
unlink($filename.'_tmp');
}
/* ------------------8<------------------------*/
----
Manual Page -- http://www.php.net/manual/en/function.fgetcsv.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+47594
Delete -- http://master.php.net/manage/user-notes.php?action=delete+47594&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+47594&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+47594&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+47594&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+47594&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+47594&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+47594&report=yes
Search -- http://master.php.net/manage/user-notes.php