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

| |

Laravel Jenkins CI

Byalexrusin

This article covers installation of Jenkins on Ubuntu server and its usage to continuously integrate a Laravel application.  Besides LAMP/LEMP stack we need to install Java, Git, Composer, and Node to successfully use Jenkins. Before starting to install this software, let’s take care of miscellaneous  stuff. Miscellaneous (can skip this). Create mysql user and database….

Share this article
|

Running Artisan Command as a Separate PHP Process in Laravel

Byalexrusin

In Laravel framework you can create commands and call them from php application.  One command can call another command, and another command, and so on.  But if an exception is thrown in one of the commands in this chain the whole chain breaks.  In order to avoid this problem and run each artisan command as…

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