Re: Removing a return character
| From: | Raditha Dissanayake | Date: | Fri, 10 Dec 2004 13:18:29 +0000 |
| Subject: | Re: Removing a return character | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-203925@lists.php.net to get a copy of this message | ||
Shaun wrote:
Hi, I have a system that scans through a CSV File and inserts each row into a database. I have just noticed that some rows have a return character in them - a small square - and this is causing errors in the mysql query. Does anyone know how I can remove such chracters? Options range from lowly trim() through str_replace() to regular expression. depends on your data.-- Raditha Dissanayake. ------------------------------------------------------------------ http://www.radinks.com/print/card-designer/ | Card Designer Applet http://www.radinks.com/upload/ | Drag and Drop Upload