Strange bug with Affordable Mobiles and Tesco Mobile feeds

[Powerup]

Tweet

Noticed a strange bug with my scripts to split the CSV files from Affordable Mobiles and Tesco feeds and put them in to a database the other day.

I am using PHP's fgetcsv command to extract the fields from the CSV file that I want and put them in to the database.

The strange behaviour is that when I get the data for the free gifts and it contains a double quote in it, then the double quote gets moved to the end of the string - i.e.

The CSV file contains a field with:
Toshiba 26" LCD TV

When this is extracted using fgetscv and ends up in my database the " has moved to the end and it looks like this:

Toshiba 26 LCD TV"

If anyone has come across this in PHP before or your feeds have been playing up please let me know.

Thanks.

[Powerup]

If you want to check the code, I have stripped it down to the most basic elements I can:

$handle = fopen("affordable.csv", "r");
	
while (($data = fgetcsv($handle, 4096, ',', '"')) !== FALSE) {
  echo $data[0];
}

where the CSV file contains just:
"Toshiba 26" LCD TV"

[jamie07051975]

If you want to check the code, I have stripped it down to the most basic elements I can:

$handle = fopen("affordable.csv", "r");
	
while (($data = fgetcsv($handle, 4096, ',', '"')) !== FALSE) {
  echo $data[0];
}

where the CSV file contains just:
"Toshiba 26" LCD TV"

If the double quotes is not after a comma then I would suggest changing it to be:

" 

If you're not sure how to do this then let me know.

[Powerup]

Hi Jamie,
Thanks for the replies.

Do you mean something like str_replace:

echo str_replace('"', '"', $data[0]);

I tried that but I just end up with:

Toshiba 26 LCD TV"

Also something like:

echo mysql_escape_string($data[0]);

Gives me Toshiba 26 LCD TV\"