<?php
$gradeCell = 'EPR 5+'; //get the cell value
$gradeValue = filter_var($gradeCell, FILTER_SANITIZE_NUMBER_INT
); //grade numerical value (the number from cell) //See if it has +, add a 0,5 then
$hasPlus = strpos($gradeCell, '+'); if ($hasPlus !== FALSE) {
$gradeValue = $gradeValue[0] + 0.5;
}
echo $gradeValue;
?>
PD9waHAKICAgICAgICAkZ3JhZGVDZWxsID0gJ0VQUiA1Kyc7IC8vZ2V0IHRoZSBjZWxsIHZhbHVlCiAgICAgICAgJGdyYWRlVmFsdWUgPSBmaWx0ZXJfdmFyKCRncmFkZUNlbGwsIEZJTFRFUl9TQU5JVElaRV9OVU1CRVJfSU5UKTsgLy9ncmFkZSBudW1lcmljYWwgdmFsdWUgKHRoZSBudW1iZXIgZnJvbSBjZWxsKQogICAgICAgIC8vU2VlIGlmIGl0IGhhcyArLCBhZGQgYSAwLDUgdGhlbgogICAgICAgICRoYXNQbHVzID0gc3RycG9zKCRncmFkZUNlbGwsICcrJyk7CiAgICAgICAgaWYgKCRoYXNQbHVzICE9PSBGQUxTRSkgewogICAgICAgICAgICAkZ3JhZGVWYWx1ZSA9ICRncmFkZVZhbHVlWzBdICsgMC41OwogICAgICAgIH0KICAgICAgICBlY2hvICRncmFkZVZhbHVlOwoKPz4=