PHP issue in csv output with quotes

Question

Hello I have a csv file when I open it in excel it looks like clean with no quotes at the starting or the ending of each line, same thing in wordpad it looks like this :

10038,"Service, Inc.",loten,[email protected],9951,xxx,6321
10041,RoadsideInc.,Kgel,[email protected],1101,xxx,7967
10042,RangLLC,Resgers,[email protected],2073,4611,xxx
10050,5-Dg,5-dg,[email protected],3-4874,2838389,xxx
10053,SandserviceInc.,Service Center Inc.,[email protected],6-5556,861398,xx
10055,CenStammddy ,Mman,[email protected],6-1449,xx,36-3755
10060,"BetsyRES, C",ElHies,[email protected], 8-0306,237602,xx
10061,Hampnemes LLC,[email protected],83-7999,xxx,-74-1043,xx
10066,CarReal LLC,CarPRea LLC,[email protected],8889,456440,xx

when I read that file in PHP via the script below I get the valid result I want wich is like the folowing :

Array
(
    [0] => 10038|Service, Inc.|loten|[email protected]|9951|xxx
    [1] => 10041|RoadsideInc.|Kgel|[email protected]|1101|xxx
    [2] => 10042|RangLLC|Resgers|[email protected]|2073|4611
    [3] => 10050|5-Dg|5-dg|[email protected]|3-4874|2838389
    [4] => 10053|SandserviceInc.|Service Center Inc.|[email protected]|6-5556|861398
    [5] => 10055|CenStammddy |Mman|[email protected]|6-1449|xx
    [6] => 10060|BetsyRES, C|ElHies|[email protected]| 8-0306|237602
    [7] => 10061|Hampnemes LLC|[email protected]|83-7999|xxx|-74-1043
    [8] => 10066|CarReal LLC|CarPRea LLC|[email protected]|8889|456440
)

when I read the file and save the array I get into a new csv file as output using the PHP code down below I get an output csv file that looks ok in excel but opened in wordpad I see many lines that start and end with quotes like the following :

"10038|Service, Inc.|loten|[email protected]|9951|xxx"
10041|RoadsideInc.|Kgel|[email protected]|1101|xxx
10042|RangLLC|Resgers|[email protected]|2073|4611
10050|5-Dg|5-dg|[email protected]|3-4874|2838389
"10053|SandserviceInc.|Service Center Inc.|[email protected]|6-5556|861398"
"10055|CenStammddy |Mman|[email protected]|6-1449|xx"
"10060|BetsyRES, C|ElHies|[email protected]| 8-0306|237602"
"10061|Hampnemes LLC|[email protected]|83-7999|xxx|-74-1043"
"10066|CarReal LLC|CarPRea LLC|[email protected]|8889|456440"

Is there something wrong with the way I'm saving the csv output file please?

<?php

function createCSV($rows){
    $csv_filename = "output.csv";
    $fp = fopen($csv_filename, "w");
    foreach ($rows as $field) {
      fputcsv($fp, array($field));
    }
    fclose($fp); 
    echo "csv created";
}
$result = array();
        $row = 1;
        if (($handle = fopen(__DIR__.'/stack.csv', "r")) !== FALSE) {
            while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                $data_row = array(
                    $data[0],
                    $data[1],
                    $data[2],
                    $data[3],
                    $data[4],
                    $data[5]
                 );                            
                $result[] = implode("|", $data_row);
                $row++;
            }
        }
        echo "<pre>";
        print_r($result);
        echo "</pre>";
        fclose($handle);
        createCSV($result);

the csv input and output files are below :

input csv

output csv

You are using implode("|", $data_row) to fix all items into one so that's what you get: one value. — Álvaro González
– Álvaro González, Commented Jul 11, 2014 at 17:06
When theres a space, the csv will surround the string with quotes to show its one thing — Ben Craig
– Ben Craig, Commented Jul 11, 2014 at 17:25

ArtisticPhoenix · Accepted Answer · 2014-07-11 18:02:28Z

1

Hi try saving the data like this

fputcsv ( resource $handle , array $fields [, string $delimiter = "," [, string $enclosure = '"' ]] )

OR in your case

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                $data_row = array(
                    $data[0],
                    $data[1],
                    $data[2],
                    $data[3],
                    $data[4],
                    $data[5]
                 );                            
               // $result[] = implode("|", $data_row); -- change this line to
                 $result[] =  $data
                $row++;
            }

change this function to include your delemiter, and don't wrap $field ( which is an array ) in another array

function createCSV($rows){
    $csv_filename = "output.csv";
    $fp = fopen($csv_filename, "w");
    foreach ($rows as $field) {
      fputcsv($fp, $field, "|");
    }
    fclose($fp); 
    echo "csv created";
}

Update here is a more efficient way to do it ( you don't need to build the results array and loop 2 times )

        $csv_filename = "output.csv";
        $fp = fopen($csv_filename, "w");
        if (($handle = fopen(__DIR__.'/stack.csv', "r")) !== FALSE && $fp) {
            while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                $data_row = array(
                        $data[0],
                        $data[1],
                        $data[2],
                        $data[3],
                        $data[4],
                        $data[5]
                );

                echo "<pre>";
                print_r($data_row);
                echo "</pre>";
                fputcsv($fp, $data_row, "|");
            }
        }

        fclose($handle);
        fclose($fp);
        echo "csv created"

edited Jul 11, 2014 at 18:02

answered Jul 11, 2014 at 17:20

ArtisticPhoenix

21.7k2 gold badges27 silver badges38 bronze badges

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

4 Comments

user3593154 Over a year ago

Sorry I did this :

$data_row = $data[0]."|".$data[1]."|".$data[2]."|".$data[3]."|".$data[4]."|".$data[5];                                           array_push($result, str_replace('"', '', $data_row));

and I still have quottes at the bigening and the ending of some line when I open the file in wordpad

ArtisticPhoenix Over a year ago

because that is the same as implode, just leave it in an array, and write it with fputcsv with the "|" as the delimiter, as in my example.

user3593154 Over a year ago

your exemple is giving Array in each csv line that is why I had to do like I showed, can you correct it please?

ArtisticPhoenix Over a year ago

@user3593154 - that was the original problem then adding the implode just hid it. did you change fputcsv($fp, array($field)); to fputcsv($fp, $field); without the array? -- updated the answer for that.

clami219 · Accepted Answer · 2014-07-11 18:04:57Z

0

You need to change the function call you use to write on disk as follows:

fputcsv($fp, array($field),"|","");

This because the last parameter is the one defining the enclosure string of your lines, as described in the php manual:

int fputcsv ( resource $handle , array $fields [, string $delimiter = "," [, string $enclosure = '"' ]] )

And the default value is the quote you want to remove

answered Jul 11, 2014 at 18:04

clami219

3,0131 gold badge34 silver badges48 bronze badges

3 Comments

ArtisticPhoenix Over a year ago

clami219 Over a year ago

Check the output... You have quotes at the end and beginning of lines that you don't have in the original cvs... OP wrote: "when I read the file and save the array I get into a new csv file as output using the PHP code down below I get an output csv file that looks ok in excel but opened in wordpad I see many lines that start and end with quotes like the following...". So the problem OP is talking about IS regarding quotes

user3593154 Over a year ago

what do you mean something like that : fputcsv($fp, array($field),"|",'"'); ?

Collectives™ on Stack Overflow

PHP issue in csv output with quotes

2 Answers 2

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related