fgetcsv() function not recognising GBP - british pound character

[samadams83]

I am trying to get data from a CSV file using the fgetcsv function, but it seems to be ignoring the British pound character.

E.g. when i try and collect the data £500 from the file, it is returned as just 500.

I am attempting to use the function like this:

 

while ($row = fgetcsv($file_handle, 2000, $delimiter))
{
    //do something with the data
}

 

I also know the data is correct in the file itself, because this much clumsier version returns the right value:

 

while ($line = fgets($file_handle))
{
    $row = explode($delimiter, $line);
}

 

I would use this version, but it doesn't have the qualifier (e.g. double-quote) functionality i need.

 

Without using a large parsing function to get through the data, does anyone know how i can make fgetcsv() not strip out the £(pound) sign?

[rarebit]

I tried this, but it does seem to be csv or in a newer version than i'm using...

 

However have a look at the first comment here

[rarebit]

$handle = fopen("mycsv.csv", "r");
while ($line = fgets($handle))
{
    $row = preg_split( "/[\s,]*\\\"([^\\\"]+)\\\"[\s,]*|[\s,]+/", $line, 0, PREG_SPLIT_DELIM_CAPTURE );
    print_r($row);
    print "<br>";
}
fclose($handle);

[samadams83]

Thanks for that, very useful. Now all i need to do is understand that regex!

 

I also found another less universal solution: if an enclosure (e.g. ") is used on the data being read, the £ sign will show up correctly. Bug in PHP?