How to skip specific line from csv file using fgetcsv function

Question

I have function which read csv file in the array. my code is

public function csvExtract() 
     {   


       $file_handle = fopen(text.csv, 'r');

       while (!feof($file_handle) )
        {
            arraydata[] = fgetcsv($file_handle, 1024);
        }

        fclose($file_handle);
    }

what i need is:

my file contain last row which has FINAL TOTAL that row i want to skip .

how to do this. Can any one help me on this.

thank you.

Mark Baker · Accepted Answer · 2013-09-27 11:17:09Z

2

Once you've finished your read loop:

end($arraydata);
$key = key($arraydata);
unset($arraydata[$key]);

or simply

array_pop($arraydata);

answered Sep 27, 2013 at 11:17

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Comments

NDM · Accepted Answer · 2013-09-27 11:23:41Z

1

You can skip any loop in PHP with the continue statement. This will only skip 1 iteration of the loop, as apposed to the break statement, which will end the loop completely.
Using this, you can form a condition for when the loop should skip:

while (!feof($file_handle)) {
    $csv = fgetcsv($file_handle, 1024);
    // check your condition and skip if needed...
    if (in_array('FINAL TOTAL', $csv)) continue;
    $data[] = $csv;
}

answered Sep 27, 2013 at 11:23

NDM

6,8483 gold badges42 silver badges55 bronze badges

2 Comments

snehal Over a year ago

thank you NDM. but here one small problem when i used this it is giving me warring as follows :Warning: in_array() expects parameter 2 to be array, boolean given in 99 where line 99 have this statement if (in_array('FINAL TOTAL', $csv)) continue;

NDM Over a year ago

Well, you have to make sure the code in the if is correct for your data, also be sure to check if fgetcsv returns an array, as it returns false on failure

donald123 · Accepted Answer · 2013-09-27 11:17:02Z

0

quick dirty solution

 ...
 fclose($file_handle);
 if($arraydata) {
    unset($arraydata[count($arraydata)-1)]);
 }

just "delete" the last row from your import

answered Sep 27, 2013 at 11:17

donald123

5,7883 gold badges28 silver badges24 bronze badges

Collectives™ on Stack Overflow

How to skip specific line from csv file using fgetcsv function

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related