Replace Funky Characters While Importing CSV

Byalexrusin

Sometimes uploaded text/csv file may have non-utf8 or other funky characters using the function below. 

public static function processUploadedBundles($request)
	{
		$content = file_get_contents($request->file('uploadedFile')->getRealPath());
 
        $lines = explode(PHP_EOL, $content);
        $array = [];
        foreach ($lines as $line) {
            $arrayCsv = str_getcsv($line, ",");
            $arrayCsv = array_map(function($value){
                return preg_replace('/[\x00-\x1F\x7F-\xFF]/', '', $value);
            }, $arrayCsv);
            $array[] = $arrayCsv;
		}
 
		return $array;
	}
Share this article

Similar Posts

|

Using PhpMyAdmin With Homestead

Byalexrusin

Laravel Homestead includes a lot of software, but unfortunately does not have PhpMyAdmin.  You can always install it on nginx, but if you have it already on your host system (for example, as a part of xampp package), you can always configure it as a Nginx site. First of all, you need to edit your config.inc.php file.  At…

Share this article
|

Contact Form Processing with PHP, MySQL, and Swift Mailer

Byalexrusin

In this article we will take a look how to process a contact form on your web page. We will collect the data from input fields, server side validate it by checking if fields are empty, put website user’s message in the database, and send a notification email to the website owner.

Share this article

Stream Filter

Byalexrusin

In php one can use filters with streams.  Sometimes it can become handy.  Let’s say you open a .csv file as a stream, but this file is tab separated.  Your program can can process coma separated csvs, but not tab separated.  This is a good use case for a stream filter, because it can make replacements…

Share this article
|

Testing API Clients

Byalexrusin

Since an API client is a boundary between your code and the outside world you should write as little code as possible to implement it. The client should strictly do its job by sending a request and returning a response. That is why we don’t really test the clients themselves but rather the code that processes the response from the client.

Share this article