PHP reading csv and using fputcsv: how can I skip the whole row with an if condition

Question

I am trying to recreate a csv file based on another csv source file. I am trying to skip the whole row when that row has a specific word "WORDO". For now I'm only able to replace the data which has "WORDO" by some empty string (""). However I would like to skip the whole row when a match is found, . For now the $keepColumns array still keeps data[1] ( empty, or not) I would like to skip the whole row when "WORDO" is inside $data[1]

<?php

$finalArray = array();
$newFinalData = "new_csv.csv";

if (($finalData = fopen("mycsv.csv", "r")) !== FALSE)
    {

    $newfile = fopen($newFinalData, 'w');

    while (($data = fgetcsv($finalData, 999999, ",",'"')) !== FALSE)
        {

        //If the 1st column has WORDO as text, ideally skip the whole row
        if( substr( $data[1], 0, 5 ) === "WORDO" ) {
            $data[1] = "";
        }

        $keepColumns = array(

            $data[0],
            $data[1],
            $data[2],
            $data[5]

        );

        fputcsv($newfile, $keepColumns, ";",'"');
        }
    fclose($finalData);
    fclose($newfile);
    }


?>

Use the word continue;

Farkie
– Farkie

2016-06-30 20:34:21 +00:00
Commented Jun 30, 2016 at 20:34 — Farkie
– Farkie, Commented Jun 30, 2016 at 20:34

Farkie · Accepted Answer · 2016-06-30 20:35:45Z

2

You should use the keyword continue to literally skip to the next iteration:

        if( substr( $data[1], 0, 5 ) === "WORDO" ) {
            $data[1] = "";
            continue;
        }

answered Jun 30, 2016 at 20:35

Farkie

3,3372 gold badges25 silver badges35 bronze badges

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

3 Comments

Don't Panic Over a year ago

Incidentally, $data[1] = ""; becomes irrelevant if you're just going to continue.

AbraCadaver Over a year ago

And I would probably use if(strpos($data[1], "WORDO") === 0)

Farkie Over a year ago

He might use it later, you never know.

Collectives™ on Stack Overflow

PHP reading csv and using fputcsv: how can I skip the whole row with an if condition

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related