How to parse CSV with values that contain a comma?

Question

Assuming you have a string as follows:

$str = 'one value, two value, "three, cool value", four value';

How would you make it an array as follows:

$arr = array('one value', 'two value', 'three, cool value', 'four value');

(That's all about CSV and values that contain a comma and thus are double quoted.)

Answer 1

You could look around at fgetcsv.

Answer 2

If you are really parsing it from a string, use str_getcsv.

If you are reading data from a file, use fgetcsv.

Answer 3

Assuming you're using 5.3.0 or newer, use str_getcsv. If you're using an older version of PHP, try fgetcsv with the 'var' stream wrapper from here. An example of the last can be found at this codepad.

Answer 4

You can use str_getcsv

$str = 'one value, two value, "three, cool value", four value';
var_dump(str_getcsv($str));                                     

Results:

array(4) {
  [0]=>
  string(9) "one value"
  [1]=>
  string(9) "two value"
  [2]=>
  string(17) "three, cool value"
  [3]=>
  string(10) "four value"
}

Answer 5

There are two ways.

1. If you're going to quote entries, quote every entries. Then explode the string with "," (with quotes).

2. Replace commas with something uncommon before parsing. Like {|}