Re: [GENERAL] How to remove "enter" or new line

2010-10-14 Thread Thom Brown
On 14 October 2010 14:59, paulo matadr 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 the

[GENERAL] How to remove "enter" or new line

2010-10-14 Thread paulo matadr
Hi Gurus, How to remove "enter" or new line from varchar field, I believed be chr(10) and chr(13). Regards Paulo