Thursday, February 14, 2019

Parsing CSV on PHP

This is a PHP function that you can use in parsing CSV that will return an array.

This will parse even a non Windows CSV format which is difficult to parse with hidden new lines.

Hope this helps a lot!

public function csvToArray($filename='', $delimiter=',') { 
  if (!file_exists($filename) || !is_readable($filename)) return FALSE;
  $header = ''; 
  $data = array(); 

  if (($handle = fopen($filename, 'r')) !== FALSE) :
    $tmpfile = fopen("$filename.tmp", 'w+');
    while(!feof($handle)) {
      $line = trim(fgets($handle));
      $lines = preg_split("(\r|\n|\r\n)", $line);
      foreach ($lines as $row) : 
        fwrite($tmpfile, "$row\n");
      endforeach; 
    }
    fclose($tmpfile);
    fclose($handle);
  endif;

  if (($handle = fopen("$filename.tmp", 'r')) !== FALSE) : 
    while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) {
      if (!@$row[0]) continue; if (!$header) : 
        $header = $row;
      else :
        $data[] = array_combine($header, $row);
      endif;
    }
    fclose($handle);
  endif;

  unlink("$filename.tmp");
  return $data;
}

1 comment:

  1. Get excellence difference between SSL and TLS, Their have proper explain of web security and insecurity that a bis reason of the excellence of this article.
    Germany VPS Server Hosting

    ReplyDelete

Leadership 101


  • Leadership demands sacrifices for the near-term to receive lasting benefits. the longer we wait to make sacrifices, the harder they become. Successful people make important decisions early in their life, then manage those decisions the rest of their lives.
  • Growth does not happen by chance. If you want to be sure to grow, you need a plan something strategic, specific, and scheduled. it's a discipline that would need incredible determination from us.
  • Success comes by going the extra mile, working the extra hours, and investing the extra time. The same is true for us. If we want to get to excel in any segment of life, a little extra effort can help. Our efforts can go a long way if we only work a little smarter, listen a little better, push a little harder, and persevere a little longer.
  • Making a difference in your work is not about productivity; it's about people. When you focus on others and connect with them, you can work together to accomplish great things.
  • Envision a goal you'd like to reach. Make it big enough to scare you a little. Now write down a plan for moving toward it. Create mini-goals within the big goal, to set yourself up for continual progress. And include some risks, too. Set yourself up for success.
  • Leaders build margins, not image. A leader may be forced to take unpopular stands for the good of the company. Popularity isn't bad, but decisions made solely on the basis of popular opinion can be devastating. So take courage and make the right though sometimes painful choices.