Split a flat array into a 2d array with chunked rows when a delimiting element is encountered

Question

I have array with ~ 10000 values.

Example:

  $arr = array("Name", "1.00", "87.70", "12.30",     
  "3.30", "3.30", "0.00", "3.50", "2.10", "1.11", "0.10", "14.00",
  "4.80", "0.00", "4.80", "0.00", "0.70", "44.00", "12.00", "85.00", 
  "138.00", "118.00", "0.10", "0.32", "1.00", "9.00", "40.00", "0.05", 
  "0.11", "0.04", "0.17", "0.10", "0.70", "5.00", "0.05", "0.40", 
  "1.00", "0.00", "65.00", "^_^", "Name2", "1.00", 
  "88.00", "12.00", "3.30", "3.30", "0.00", "3.20", "1.92", "1.01", 
  "0.08", "13.00", "4.80", "0.00", "4.80", "0.00", "0.70", "44.00", 
  "12.00", "85.00", "139.00", "118.00", "0.10", "0.32", "1.00", "9.00", 
  "36.00", "0.00", "0.10", "0.04", "0.17", "0.10", "0.70", "7.00", 
  "0.05", "0.40", "1.00", "0.00", "61.00", "^_^",

and so on....

I need to explode array when it reach value in array "^_^" and make array in array. And then I will and info into database.

I tried to explode, foreach and explode but didn't find a solution for this problem.

Answer 1

You will need to write your own function to do this. Here is a simple example that should explain it:

function array_split($arr, $splitBy) {
    $result = [];
    $subArray = [];

    foreach ($arr as $elem) {
        // If an element matches your delimiter,
        // add the current sub-array to the result set and start a new sub-array
        // Else add the element to the sub-array
        if ($elem == $splitBy) {
            $result[] = $subArray;
            $subArray = [];
        } else {
            $subArray[] = $elem;
        }
    }

    // Make sure the last sub-array also gets added to the result set
    $result[] = $subArray;

    return $result;
}