note 112846 added to function.str-getcsv

<?php /** * This is the simplest way to do a csv line getter i could imagine. * It's not perfect at all, but will do the job. * There are indeed some error checks for very badly formated csv lines. * It will not, for example, handle the last field if it's empty, * and it will omit repeated enclosures inside quoted fields if * they are not escaped, but I tried to do it very clearly * so everyone could change it for your own necessities. * @param string $str String * @param string $delimiter String * @param string $enclosure String * @param string $escape String * @return array */ function user_str_getcsv($str, $delimiter=',', $enclosure='"', $escape='\\') { $return = array(); $fields = 0; $inside = false; $quoted = false; $char = ''; //Let's go through the string for ($i=0; $i<mb_strlen($str); $i++) { $char = mb_substr($str, $i, 1, 'UTF-8'); if (!$inside) { //Check if we are not inside a field if ($char == $delimiter) { //Check if the current char is the delimiter //Tells the function that we are not inside a field anymore $inside = false; $quoted = false; //Jumps to the next field $fields++; } elseif($char == $escape) { //Check if the current char is the escape //Error, because it isn't inside a field and there is a escape here return false; } elseif($char != ' ') { //Check if the current char isn't a blank space //Tells the function that a field starts $inside = true; //Check if the current char is the enclosure, indicating that this field is quoted if ($char == $enclosure) { $quoted= true; } else { $return[$fields] .= $char; } } } else { //Here we are inside a field //Check if the current char is the escape if ($char == $escape) { //Check if the string has one more char beyond the current one if (mb_strlen($str)>$i+1) { //Tells the function we will treat the next char $i++; $char = mb_substr($str, $i, 1, 'UTF-8'); //Check if our new char is the enclosure if ($char == $enclosure) { //Check if the field is a quoted one if ($quoted) { $return[$fields] .= $enclosure; } else { //Error, because we have an escape and then we have an enclosure and we are not inside a quoted field return false; } } elseif ($char == $escape) { $return[$fields] .= $char; } else { eval("\$return[\$fields] .= \"\\".$char."\";"); } } else { //Error, because there is an escape and nothing more then return false; } } elseif ($char == $enclosure) { //Check if the current char is the enclosure //Check if we are in a quoted field if ($quoted) { //Tells the function that we are not inside a field anymore $inside = false; $quoted = false; } else { //Error, because there is an enclosure inside a non quoted field return false; } } elseif ($char == $delimiter) { //Check if it is the delimiter //Check if we are inside a quoted field if ($quoted) { $return[$fields] .= $char; } else { //Tells the function that we are not inside a field anymore $inside = false; $quoted = false; //Jumps to the next field $fields++; } } else { $return[$fields] .= $char; } } } return $return; } print_r(user_str_getcsv("test,1,\"B,C,D\",\"with a escape\\\\\", \"with an enter\\n\", \"with an enclusure enclosure\\\"\"")); exit(0); ?> The response will be: Array ( [0] => test [1] => 1 [2] => B,C,D [3] => with a escape\ [4] => with an enter [5] => with an enclusure enclosure" ) ---- Server IP: 69.147.83.199 Probable Submitter: 143.106.64.147 ---- Manual Page -- http://php.net/manual/en/function.str-getcsv.php Edit -- https://master.php.net/note/edit/112846 Del: integrated -- https://master.php.net/note/delete/112846/integrated Del: useless -- https://master.php.net/note/delete/112846/useless Del: bad code -- https://master.php.net/note/delete/112846/bad+code Del: spam -- https://master.php.net/note/delete/112846/spam Del: non-english -- https://master.php.net/note/delete/112846/non-english Del: in docs -- https://master.php.net/note/delete/112846/in+docs Del: other reasons-- https://master.php.net/note/delete/112846 Reject -- https://master.php.net/note/reject/112846 Search -- https://master.php.net/manage/user-notes.php