2010/2/27 <seil...@so-net.net.tw>: > Hi! > > I am trying to replace characters '\r', '\n', or '\t' with space character ' > '. As an example, I want string "A\t\n\rB" becomes "AB". The following > statement seems to be not working. What mistake have I made? > > TIA > > CN > ======== > > select regexp_replace(E'A\r\n\tB',E'[\r\n\t]',' '); > regexp_replace > ---------------- > A > B > (1 row) >
Try: select regexp_replace(E'A\r\n\tB',E'[\r\n\t]',' ','g'); Osvaldo -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general