Parse string from array to use in csv

Question

I'm generating a array that record looks like:

315 => 
array (size=3)
  0 => string 'Bangkok ICD' (length=11)
  1 => string '[pc_315]' (length=8)
  2 => string '45.00;5600.00;677.78;45.00;454.00;;;;'

Next I'm putting this array in csv using simple method:

private function fill_file_data($list)
{
    $file = $this->csv_file_path."/tariff_{$this->freight_tariff->id}_matrix.csv";

    if (!file_exists($file))
    {
        file_put_contents($file, "");
    }

    $file_handler = fopen($file, 'w');

    foreach ($list as $fields)
    {
        fputcsv($file_handler, $fields, $this->delimiter, $this->separator);
    }

    fclose($file_handler);
    return;
}

But there is a problem with this part :

2 => string '45.00;5600.00;677.78;45.00;454.00;;;;'

It is separated by semicolon but fputcsv treats this as a string. Is there a way to read this part as csv columns?

So explode string with these values by ; and add to csv

u_mulder
– u_mulder

2015-02-11 13:48:16 +00:00
Commented Feb 11, 2015 at 13:48 — u_mulder
– u_mulder, Commented Feb 11, 2015 at 13:48

u_mulder · Accepted Answer · 2015-02-11 13:52:44Z

2

I think you should explode your string by ; and add this values as new array elements, for example

$arr = array(
    'Bangkok ICD',
    '[pc_315]',
    '45.00;5600.00;677.78;45.00;454.00;;;;'
);
$new_values = explode(';', $arr[2]);
// now we remove string '45.00;5600.00;677.78;45.00;454.00;;;;'
unset($arr[2]);
$arr = array_merge($arr, $new_values);

After that you can pass this item to your method.

answered Feb 11, 2015 at 13:52

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Parse string from array to use in csv

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related