replace empty CSV values with something - PHP

Question

Im using a CSV Import plugin for open cart and by default is completely skips products if they are missing any of the column fields. Is there anyway i can read the file and replace all the empty fields with 'null' or 0 and send it back to the code.

skipping that check below causes an offset in the reading/placing format !

    $fh = fopen($file, 'r');
    if(!$fh) die('File no good!');

    // Get headings
    $headings = fgetcsv($fh, 0, $delim);
    $num_cols = count($headings);
    $num_rows = 0;

    //Read the file as csv
    while (($row = fgetcsv($fh, 0, $delim)) !== FALSE) {

         //missed product if num columns in this row not the same as num headings
     if (count($row) != $num_cols) {
        $this->total_items_missed++;
        continue;
        }   


        for ($i=0; $i<count($headings); $i++) {
            $raw_prod[$headings[$i]] = $row[$i];
        }

remove the 4 lines that do the check, depending what you do with the data next that may be all you need. — user557846
– user557846, Commented Oct 24, 2011 at 19:42
that just causes an offset here then, $raw_prod[$headings[$i]] = $row[$i]; — Neo
– Neo, Commented Oct 24, 2011 at 19:58

Jay Gilford · Accepted Answer · 2011-10-24 20:36:45Z

1

Replace these two lines

$this->total_items_missed++;
continue;

with

$row = array_pad($row, $num_cols, 0);

Which will add any missing values with 0's

answered Oct 24, 2011 at 20:36

Jay Gilford

15.2k6 gold badges39 silver badges56 bronze badges

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

2 Comments

Neo Over a year ago

thanks, that worked great ! not sure wether one below would suit better, i assume they provide same result. Never used array_pad bfore myself

Jay Gilford Over a year ago

You could only use that if you removed the column count check really...so no it wouldn't work as you want. Array pad is one of those functions that you just have to remember. I've barely ever used it myself either

user557846 · Accepted Answer · 2011-10-24 20:19:13Z

1

try

for($i = 0 ; $i<count($headings) ; $i++){
    if(!empty($row[$i])){
        $raw_prod[$headings[$i]] = $row[$i];
    }else{
        $raw_prod[$headings[$i]] = 0;//or what ever value you want
    }
}

answered Oct 24, 2011 at 20:19

user557846

Collectives™ on Stack Overflow

replace empty CSV values with something - PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related