How do I skip the first piece of data when extracting from a csv file with PHP

Question

The following code is what I am using to get an entire column of data from my csv files. (There are many columns, but I only need #2). This code will put all of the data into the array called $cbsmin. What I need to do is skip the very first piece of data in each file as it is the category name not actually a piece of data.

How would this best be done?

for($i=0;$i<count($files);$i++){
    if (($handle = fopen($files[$i], "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

            $cbsmin[] = $data[2];

        }
        fclose($handle);
    }
}

John Conde · Accepted Answer · 2013-05-27 21:27:52Z

2

Just use a simple flag to mark if it is the first line. If it is, reset the flag to false and skip that line.

$isfirst = true;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    if ($isfirst)
    {
        $isfirst = false;
        continue;
    }
    $cbsmin[] = $data[2];
}

answered May 27, 2013 at 21:27

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Comments

SteAp · Accepted Answer · 2013-05-27 21:30:32Z

2

Just execute a single

   fgetcsv($handle, 1000, ",");

before the while loop.

answered May 27, 2013 at 21:30

SteAp

12k12 gold badges56 silver badges97 bronze badges

1 Comment

Rahul Gupta Over a year ago

Yes, this would be a better solution rather than writing this much piece of code. Why write extra lines if you get the desired solution by writing only just one line.

Orangepill · Accepted Answer · 2013-05-27 21:34:24Z

Just throw in an extra read prior to going into the while loop

for($i=0;$i<count($files);$i++){
    if (($handle = fopen($files[$i], "r")) !== FALSE) {
        // eat the header
        fgetcsv($handle, 1000, ",");
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

            $cbsmin[] = $data[2];

        }
        fclose($handle);
    }
}

Another technique I use for this is to use the header row for keys in the data. This works if the header rows are consistent over time and from file to file.

for($i=0;$i<count($files);$i++){
    if (($handle = fopen($files[$i], "r")) !== FALSE) {
        // eat the header
        $header = fgetcsv($handle, 1000, ",");
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
            $data = array_combine($header, $data);
            $cbsmin[] = $data["Customer Name"];

        }
        fclose($handle);
    }
}

It beats having to use field offsets if you are doing anything non-trivial with a lot of the fields.

Collectives™ on Stack Overflow

How do I skip the first piece of data when extracting from a csv file with PHP

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related