note 90413 deleted from function.trim by hholzgra
| From: | hholzgra@php.net | Date: | Thu, 02 Aug 2012 12:30:07 +0000 |
| Subject: | note 90413 deleted from function.trim by hholzgra | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-189667@lists.php.net to get a copy of this message | ||
Note Submitter: andycbio at gmail dot com
----
A cell read from an Excel sheet appeared to have a whitespace, and this was not getting trimmed. By
converting to hex, it seems the char was a hard return.
Successfully trimmed it by:
<?php
trim($value, "\xc2\xa0");
?>
The actual hex values may vary by character set, check with bin2hex() for what's actually
there.