Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Function to remove spaces/carriage returns from text
Does anybody know how to remove a carriage return
and line feed from text in an sql statement using some function
or combination of functions.
We have a text box in a PHP front end that allows the carriage return to
be place into a description ( Text ) field.
We then later access the database to create a unix file with that
description in the file.
A perl script then reads the file and puts this text into a static web
page every night.
If the data is entered with a carriage return the script fails.
We need to remove the carriage return or line feed or both. Is there a proper function in SQL and how do we actually search for a carriage return/ line feed? How would we represent it in sqlplus for the search?
Thanks
Rob
Received on Wed Nov 29 2006 - 16:46:50 CST