Re: Removing a return character
| From: | John Nichel | Date: | Fri, 10 Dec 2004 14:09:12 +0000 |
| Subject: | Re: Removing a return character | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-203929@lists.php.net to get a copy of this message | ||
Greg Donald wrote:
On Fri, 10 Dec 2004 10:10:20 -0000, Shaun <shaunthornburgh@hotmail.com> wrote:rtrim() will take care of all return characters at the end of the line, as well as white space. The 'small square' could be something else...some special character. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.comI 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?You can use one of the string replacement functions, eregi_replace() for example. If you're sure it's a return character then \r is what you want to replace, or it might possibly be \r\n.