On 14 October 2010 14:59, paulo matadr <saddon...@yahoo.com.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
