ID: 43835
User updated by: alexander dot varchenko at gmail dot com
-Summary: fgetcsv() enclosure
Reported By: alexander dot varchenko at gmail dot com
Status: Open
Bug Type: Filesystem function related
Operating System: FreeBSD,Linux,Windows
PHP Version: 5.2.5
New Comment:
! In Actual Result -> 3 fields in line x
Previous Comments:
------------------------------------------------------------------------
[2008-01-14 00:17:07] alexander dot varchenko at gmail dot com
Description:
------------
Not every programs escapes enclosure characters,
so it's should be good to check enclosures by delimiters chars
start =delimiter+enclosure
fin = enclosure+delimiter
TEST data: test.csv [TSV]
1[tab]"NOAA "Official" Emergency"[tab]01/09/2008
2[tab]"Tories "reject" green" panel's advice"[tab]01/09/2008
Reproduce code:
---------------
<?
$handle = fopen('test.csv','rb');
$row = 1;
while (($data = fgetcsv($handle, 1000, "\t",'"')) !== FALSE) {
$num = count($data);
echo "$num fields in line $row\n";
$row++;
for ($c=0; $c < $num; $c++) {
echo "[$c]:".$data[$c]."\n";
}
}
fclose($handle);
?>
Expected result:
----------------
3 fields in line 1
[0]:1
[1]:NOAA "Official" Emergency
[2]:01/09/2008
3 fields in line 2
[0]:2
[1]:Tories "reject" green" panel's advice
[2]:01/09/2008
Actual result:
--------------
4 fields in line 1
[0]:1
[1]:NOAA Official" Emergency"
[2]:01/09/2008
4 fields in line 2
[0]:2
[1]:Tories reject" green" panel's advice"
[2]:01/09/2008
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=43835&edit=1
