Re: How to remove "enter" or new line

On 14 October 2010 14:59, paulo matadr <saddoness(at)yahoo(dot)com(dot)br> wrote:
>
> Hi Gurus,
>
>
> How to remove "enter" or new line from varchar field, I believed  be chr(10)
> and chr(13).

You can use regexp_replace. For example:

regexp_replace(column, '\r|\n', '', 'g')

Bear in mind, the above example would mean that if there was no
whitespace between the newline and the words either side of it, they
would effectively be concatenated, so you may wish to replace with a
space, or use a better regular expression.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935