Hello all,
I have a text file (its comma delimited with some fields wrapped around in double quotes) when I parse through it using this:
if (($handle = fopen('C:\tester\fake.txt', "r")) !== FALSE) {
while (($data = fgetcsv($handle, ",")) !== FALSE) {
$num = count($data);
//echo "<p> $num fields in line $row: <br /></p>\n";
$row++;
for ($c=0; $c < $num; $c++) {
echo $data[$c] . "<br />\n";
}
}
fclose($handle);
}
It shows each field not to have quotes, does the fgetcsv remove this automatically?
How can I get it to show fields that do not have quotes and add quotes to them and then save the file? Possible?
Thanks all
Update
I have just tried the fputcsv and I find the file written doesn't have quotes around the fields, only very few, less than the initial file had! What am I doing wrong?
$row = 1;
$newfile = fopen('C:\new-file.txt', "w");
if (($handle = fopen('C:\fake.txt', "r")) !== FALSE) {
while (($data = fgetcsv($handle, ",")) !== FALSE) {
$num = count($data);
fputcsv($newfile, $data, ',', '"');
}
fclose($handle);
fclose($newfile);
}