PHP Remove columns from csv

Question

I need to remove some columns and the first row from a csv and put the result in a new csv file. I tried already with some sugesstions found here on stack, but none of them will work for me. My csv has 9 columns but i only need 5 of them. The best found solution here to remove the columns seems to be the one i will post below, but i only get commas in the result file and some where some data. The data in my csv are spararted with ';' I hope any one can help me.

Here is the code i played with:

<?php
 $input = 'gesamtbestand.csv';
 $output = 'mw-stock.csv';

 if (false !== ($ih = fopen($input, 'r'))) {
$oh = fopen($output, 'w');

while (false !== ($data = fgetcsv($ih))) {
    // this is where you build your new row
    $outputData = array($data[1], $data[2], $data[4], $data[5], $data[8]);
    fputcsv($oh, $outputData);
}

fclose($ih);
fclose($oh);
}

Thanks for the answer. But could you explain it a bit more please? — Kallmas
– Kallmas, Commented Aug 2, 2017 at 9:25

Dimitris Filippou · Accepted Answer · 2017-08-03 15:43:22Z

2

The default delimiter for fgetcsv is , as you can see in php manual http://php.net/manual/en/function.fgetcsv.php

If your csv file uses ; for delimiter then you should change the line

while (false !== ($data = fgetcsv($ih))) {

to

while (false !== ($data = fgetcsv($ih, 0, ";"))) {

The default enclosure is "

if you don't use an enclosure in your data then you should change the line to

while (false !== ($data = fgetcsv($ih, 0, ";", ""))) {

As for excluding the first entry of the csv file you can do this

$i=0;
while (false !== ($data = fgetcsv($ih))) {
    // this is where you build your new row
    if ($i!=0){
        $outputData = array($data[1], $data[2], $data[4], $data[5], $data[8]);
        fputcsv($oh, $outputData);
    }
$i++;
}

edited Aug 3, 2017 at 15:43

answered Aug 2, 2017 at 12:11

Dimitris Filippou

8096 silver badges13 bronze badges

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

8 Comments

Kallmas Over a year ago

Yeah. This was really a great help. It works now. Thank you so much. :)

Kallmas Over a year ago

BTW. Is there also a way to remove also the first row of the new file?

Dimitris Filippou Over a year ago

You want the first row of the output file to be empty? Or you want to exclude the first line of the input file?

Kallmas Over a year ago

I want to exclude the first row completely. Because after i removed the columns the content of the new csv will be added to another csv. It works allready thanks to you and it's just a cosmetic thing. :)

Dimitris Filippou Over a year ago

i think we have a misunderstanding with rows and columns :) I think what u mean is that if one line of your csv is "param1;param2;param3;param4" you want to keep only "param2:param3:param4" of lines 1,2,4,5,8 right?

|

Collectives™ on Stack Overflow

PHP Remove columns from csv

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related