search for line feed characters
Is there any way to search for line feed characters in a query? I want to ignore line feeds in a column.
Leave a comment...
- 1 Comments
- CHR(10) is a linefeed and CHR(13) is a carriage return.
If you are looking for end-of-line then in UNIX it is
CHR(10) and in Windows it is CHR(13)||CHR(10)
You can use something like:
SELECT REPLACE(cr_line,CHR(10),' ')to remove linefeeds.
FROM (SELECT 'This is a line'||CHR(10)||'and another' cr_line
John#1; Fri, 22 Feb 2008 01:15:00 GMT