PHP str_replace CSV Content

Question

I am getting the contents of a CSV file and displaying (it works).

if (($handle = fopen($url, 'r')) === false) {
    die('Error opening file');
}


$headers = fgetcsv($handle, 1024, ',');
$complete = array();
while ($row = fgetcsv($handle, 1024, ',')) {
    $complete[] = array_combine($headers, $row);
}
fclose($handle);

However, in this CSV file there is a field that has contents for example like this:

"123456,123456,123456,123456"

I think my code isn't processing because of the double quotes, I think I need to convert to single quotes. If thats the case how would I integrate the following (I was thinking something like):

str_replace('"',"'", $url);

Lepidosteus · Accepted Answer · 2013-06-09 11:15:51Z

2

Look at the other parameters for fgetcsv()

By default the enclosure character is set to ", which means anything between quotes should be considered a single value. Replace that parameter with what you actually use as the enclosure character in the csv and it will work.

Something like (if your enclosure character is '):

while ($row = fgetcsv($handle, 1024, ',', "'")) {

Better than to read it wrong and try to fix it afterwards with str_replace.

edited Jun 9, 2013 at 11:15

answered Jun 9, 2013 at 11:10

Lepidosteus

12.1k4 gold badges41 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

iYugShell Over a year ago

hi,thanks for taking the time - it looks like it's working! is there a quick way to only include the header and the next row?

Collectives™ on Stack Overflow

PHP str_replace CSV Content

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related