On May 31, 2006, at 9:17 AM, Nis Jorgensen wrote:
> regexp_replace seems to do what you need:
>
> http://www.postgresql.org/docs/8.1/static/functions-matching.html
>
> Something like
>
> regexp_replace (field, '[^\u0000-\u00FF]', '?', 'g')
Yes! Thanks very much -- I looked at that page several times and
missed regexp_replace.
Here is an example:
=== psql 3 ===
select regexp_replace('©«¡®£§¼½¾¿ ÀÉÌÓÙÝ àéìóùý
āŹźŻżŽž ∧∨ wxyz', '[^\\u0000-\\u00FF]', '?', 'g');
regexp_replace
------------------------------------------
©«¡®£§¼½¾¿ ÀÉÌÓÙÝ àéìóùý ??????? ?? wxyz
(1 row)
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL