PHP Processing CSV file separated by semicolon

Question

I've a csv file with the following structure:

a; b; c,c c; d

When I try to process it, it says offset 2 and 3 are undefined. Took me a while to realize it is caused by the , and have no idea how to solve this. If I remove the , everything runs fine.

Here's my processing function:

function process_csv($file) {

    $file = fopen($file, "r");
    $data = array();

    while (!feof($file)) {
        $csvdata = fgetcsv($file);

        $data[] = explode(';', $csvdata[0]);
    }

    fclose($file);
    return $data;
}

Tried fgetcsv($file); as fgetcsv($file, '"'); but didn't help.

The separator is the third argument to fgetcsv.

mario
– mario

2015-04-07 08:43:38 +00:00
Commented Apr 7, 2015 at 8:43 — mario
– mario, Commented Apr 7, 2015 at 8:43

the · Accepted Answer · 2019-09-28 10:16:09Z

20

Your problem is, that fgetcsv uses , as delimiter by default. If you change it to ; you don't need to explode.

function process_csv($file) {

    $file = fopen($file, "r");
    $data = array();

    while (!feof($file)) {
        $data[] = fgetcsv($file, null, ';');
    }

    fclose($file);
    return $data;
}

edited Sep 28, 2019 at 10:16

the

22.1k12 gold badges75 silver badges102 bronze badges

answered Apr 7, 2015 at 8:47

Marc

3,7198 gold badges37 silver badges49 bronze badges

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

2 Comments

Kiss Koppány Over a year ago

Wow, shame on me! I did everything on a wrong way. This must be the reason why I couldn't find any topic related to my problem :) Thank you very much, now everything works as it should be!

Raphael Müller Over a year ago

@Marc, I'd suggest to keep the declaration of $data. first, you are sure that it's initialized correctly, second, if there is no line in the file, the declaration never happens and the return value is null.

Collectives™ on Stack Overflow

PHP Processing CSV file separated by semicolon

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related