Average of values in a string? [Resolved]

[TDQWERTY]

Hello all,
I came across a problem with calc an average, the thing is, i have a big string, full of values separated using ; and ,
Let me show:

$myString="1,2;2,2;1,3;2,3;2,4";

The average of that should return something like:

(1+2+1+2+2)/5
and
(2+2+3+3+4)/5

That string has 2 answers for 1 question, that would do 2 averages, not just one in this case.
Answer 1 would be 1,6
Answer 2 would be 2,8

The answers schema is: <answer1>,<answer2>;<answer1>,<answer2>;...
But it can be <answer1>,<answer2><answer3>;<answer1>,<answer2><answer3>;...
or
<answer1>;<answer1>;<answer1>;...

Does anyone have any idea on how to solve this?

[visualAd]

Here is what you need to do:

1. Use the split() function to turn the string into an array using a semi colon as a separator.
   
   
2. For each string in this new array:
   
   1. Use the split() function again, but this time use the comma as a separator and you obtain an array of number.
      
      
   2. For each number in this array append it to a new array containing the answers for each question:
      

      $count = count($answer_array);
      
      for($x = 0; $x < $count; $x++) {
          $question_array[$x + 1][] = $answer_array;
      } 

   
   
3. Your question array should contain an index for each question number, each element being an array of answers. You can then loop through this array and calculate the average for each with the help of the array_sum() function.
   

   foreach($question_array as $question_number => $answers) {
       $average_array[$question_number] = array_sum($answers) / count($answers);
   } 

4. You will now have an array of averages for each question.

[TDQWERTY]

thanks a lot!
5 Points for your answer, my question has been answered at first!

It works like a charm!