fgetcsv not reading columns which has special characters in PHP

Question

I am unable to get the column value which contains some special characters. I have checked many answers but i got no idea. I have pasted my sample code and data here,

$pHandle = fopen($filename, "r");
while (($data = fgetcsv($pHandle, 1600, ",")) !== FALSE) {
    echo $productName =  utf8_encode(htmlspecialchars(trim($data[0])));exit;
 }

It echo's nothing.

some sample data's

enter image description here

Any help will be much appreciated.

Is the CSV data well-formed? For example, does any string that contains a comma have quote marks around it? — GordonM, Jan 21 '14 at 09:32
@GordonM updated an image. The column has `-(),` even it has **single quote** — Manigandan Arjunan, Jan 21 '14 at 09:58

score 0 · Accepted Answer · answered Jan 28 '14 at 04:06

0

The function fgetcsv is not reading the string because the string contains an unknown character "-"(shown in the image) it's not hypen, i replaced the character by "-"hyphen and it worked.

enter image description here

answered Jan 28 '14 at 04:06

Manigandan Arjunan

2,260
1
25
42

fgetcsv not reading columns which has special characters in PHP

1 Answers1