Adding Columns to a CSV

[arkman]

Hello,
A little new to this, but getting there.

I have a csv that I need to add some columns to. All of the columns have default values in them. I can read the csv and get it into an array, but I'm not sure how to write the values 'into' the array.

Original csv
1, data, data
2,, data
3, data,,
etc...

New csv
1, data, data, 1, 0.00, N
2, 0, data, 1, 0.00, N
3, data, 0, 1, 0.00, N

So the three new columns will always contain the same data. As noted there I also need to take the 'nulls' and change em to zero.

I'm not even entirely sure what function is the best here.

Thanks.

[Installer]

Something like this:

$csv = file('csv.txt');
foreach ($csv as $str) {
    $values = explode(',', $str);
    foreach ($values as $key => $val) {
        if (trim($val) == '') {
            $values[$key] = '0';
        }
        $values[$key] = trim($values[$key]);
    }
    $values[3] = '1';
    $values[4] = '0.00';
    $values[5] = 'N';
    $new_str[] = implode(',', $values);
}
$new_csv = implode("\r\n", $new_str);
$fp = fopen('new_csv.txt', 'w');
fwrite($fp, $new_csv);
fclose($fp);

Assuming you don't really need those spaces after the commas. If you do, change "[FONT=Fixedsys]implode(',', $values)[/FONT]" to "[FONT=Fixedsys]implode(', ', $values)[/FONT]".

Edited for code correction.