On Fri, 10 Dec 2004 10:10:20 -0000, Shaun <[EMAIL PROTECTED]> wrote: > 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?
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. -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
