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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to