Converting CSV rows string into array

Question

I am using an API that returns a CSV string as the following:

Date,Open,High,Low,Close,Volume,Adj Close 2014-06-13,3.10,3.30,3.10,3.30,6638300,3.30

I was wondering if there is an easy way to convert this CSV string to an associative array? I am familiar with working with a CSV file, but not sure what to do with a CSV file string response. I am trying to avoid writing the response to a file, just so I can read it back.

Note, writing this response to a CSV file would result in two rows and seven columns.

You could use str_getcsv(), but you'd need to figure out where the line breaks are. What's the line terminator? — user1864610
– user1864610, Commented Jun 14, 2014 at 0:04
if the terminator is \r\n, explode them thru that, get the first element, which is the headers, then loop and create new arrays using those headers as keys — user1978142
– user1978142, Commented Jun 14, 2014 at 0:13

user1978142 · Accepted Answer · 2014-06-14 00:53:55Z

1

If the line terminator is \r\n, then first you need to explode them thru that. Then you can proces from there. Consider this example:

$data = explode("\r\n", $csv_string);
// get the headers first
$headers = array_map('trim', explode(',', array_shift($data)));
$new_data = array();
// get the values and use array combine to use the headers as keys for associative array
foreach($data as $values) {
    $pieces = explode(',', $values);
    // i just assigned it in an array, since we dont know how many lines of data you will receive
    $new_data[] = array_combine($headers, $pieces);
}

$new_data should yield something like this:

Array
(
    [0] => Array
        (
            [Date] => 2014-06-13
            [Open] => 3.10
            [High] => 3.30
            [Low] => 3.10
            [Close] => 3.30
            [Volume] => 6638300
            [Adj Close] => 3.30
        )

)

Or just the usual way of handling csv strings. Use str_getcsv().

$data = str_getcsv($csv_string, "\r\n");
$headers = explode(',', array_shift($data));
$data = array_combine($headers, explode(',',reset($data)));

edited Jun 14, 2014 at 0:53

answered Jun 14, 2014 at 0:22

user1978142

7,9683 gold badges19 silver badges20 bronze badges

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

2 Comments

AnchovyLegend Over a year ago

@JakeGould, str_getcsv() doesn't work on this input. Try it. The 7th cell is clumped with 8th, it doesn't detect the line break.

AnchovyLegend Over a year ago

@kevinabelita, thanks Kevin. Unfortunately, this did not work. I am getting this warning and the array is not lined properly: Warning: array_combine(): Both parameters should have an equal number of elements in C:\mypath\test.php on line 67

Nathan · Accepted Answer · 2014-06-14 00:54:43Z

0

As others have mentioned, str_getcsv() is your friend and is an easy method to convert a CSV string into an array. This function will return an array of results. If you'd like to make it an associative array, use array_combine().

Honestly, though -- str_getcsv() may be overkill. Consider this method using explode():

// so given this string returned by the API
$api_s = "Date,Open,High,Low,Close,Volume,Adj Close\r\n2014-06-13,3.10,3.30,3.10,3.30,6638300,3.30";

// split on carriage return & line feed into two strings
$api_r = explode("\r\n", $api_s);

// split keys and values by comma
$keys = explode(',', $api_r[0]);
$vals = explode(',', $api_r[1]);

// construct associative array
$my_assoc_r = array_combine($keys, $vals);

edited Jun 14, 2014 at 0:54

answered Jun 14, 2014 at 0:41

Nathan

1,70012 silver badges15 bronze badges

Collectives™ on Stack Overflow

Converting CSV rows string into array

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