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

Upload to FTP with PHP

Byalexrusin

$fp = fopen(’https://www.example.com/pdfdoc’, ‘r’);   $user = "sammy"; $pass = "password"; $ftp_server = "192.168.10.10";   //should be wrapped in try catch to properly handle errors $ftp_conn = ftp_ssl_connect($ftp_server); $login = ftp_login($ftp_conn, $user, $pass);   ftp_chdir($ftp_conn, ‘path/to/folder’); //can also use ftp_pwd   ftp_pasv($ftp_conn, true); //passive mode   ftp_fput($ftp_conn, "mydocument.pdf", $fp, FTP_BINARY);   fclose($fp); ftp_close($ftp_conn);$fp = fopen(‘https://www.example.com/pdfdoc’,…

Share this article