Hi,
I have a text field that has some email addresses that are each on a new
line by a CRLF.
I want to replace the CRLF with a comma so I can use the email
addresses in another app, so I thought I would do this:
thearray = replace(mandi_notifications,'/r/n',',');
but it does not work.
Does anyone know if it is possible to replace a CRLF in a string with PG
built in functions? I would rather not use Perl if possible.
Thanks,
Tony