Saving specific columns of CSV to another CSV file in PHP

Question

so trying to read a csv file and extracting details from the file and wish to store specific columns of the csv to another csv file.

I have managed to extract the specific columns of the input csv file but not really sure how I can write those extracted columns to another csv file.

Here is the part of my work:

$row = 1;
if (($handle = fopen("testtable.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        $row++;
        echo $data[0] . "\n" . $data[1] . "<br />\n";

    }
    $file = fopen("editedTable.csv","w");
    foreach ( $data as $line) {             //working on this part of the code
        fputcsv($file, explode(',',$line));
    }
    fclose($handle);
}

Obviously there is an error in the foreach loop as I am trying to work out the logic.

The data that is extracted is basically first and the second column (data[0], data[1]). Just need this to write to another CSV file. The input csv is just a comma delimited file with 5 columns. Any idea how I can modify the foreach loop and the use the fputcsv method?

Thanks

Kerkouch · Accepted Answer · 2018-09-04 05:37:10Z

1

fputcsv accepts an array on the second parameter.

I think this is what you looking for:

<?php
$file = fopen("editedTable.csv","w");
$row = 1;
if (($handle = fopen("testtable.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000)) !== FALSE) {
        $num = count($data);
        $row++;
        echo $data[0] . "\n" . $data[1] . "<br />\n";
        fputcsv($file, [$data[0], $data[1]]);
    }
}
fclose($handle);
fclose($file);

answered Sep 4, 2018 at 5:37

Kerkouch

1,46612 silver badges15 bronze badges

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

Comments

Anupam Rekha · Accepted Answer · 2018-09-04 06:47:50Z

1

Because you place the fputs outside of the $data initial loop, you catch only one row, here is the modified code.

     $row = 1;
     $file = fopen("editedTable.csv","w");

    if (($handle = fopen("testtable.csv", "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $num = count($data);
            $row++;
            echo $data[0] . "\n" . $data[1] . "<br />\n";
            $line = $data[0].", ".$data[1];
            $line .=  "\n";
            fputs($file, $line);
       }
      fclose($handle);
   }
   fclose($file);

edited Sep 4, 2018 at 6:47

answered Sep 4, 2018 at 1:49

Anupam Rekha

18510 bronze badges

Collectives™ on Stack Overflow

Saving specific columns of CSV to another CSV file in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related