PHP如何修剪，截断，复杂的数据

Question

This is some data

Case 1 "("2017-02-02 21:15:00",201,1,"E.CO-PUAS KAJANG/AC PANEL ETS",16977.00000)" Case 2 "("2017-02-02 21:15:00",201,6,"SPARE 6",)"

Im required to extract data without "(, to store into 5 variable

$date = "2017-02-02 21:15:00";

$code = 201;

$id = 1;

$name = "E.CO-PUAS KAJANG/AC PANEL ETS";

$value = 16977.00000;

Note: SOME CASE like Case 2 return without value and set to 0

Please show me some example or tips. i found tutorial trim, but it only trim one time

I wanted output will be write like this

echo $date;

echo $code;

echo $id;

echo $name;

echo $value;

Answer 1

Modifying answer to handle data better... plus this looks a lot shorter.

$str='("2017-02-02 21:15:00",201,1,"E.CO-PUAS KAJANG/AC PANEL ETS",16977.00000)'; 
$data=trim($str,'()');
$data_array=str_getcsv($data);

$date = $data_array[0];

$code = $data_array[1];

$id = $data_array[2];

$name = $data_array[3];

if($data_array!='')
    $value = $data_array[4];
else
    $value= 0;