On Thu, Nov 17, 2022 at 4:00 AM DeFreitas, Nigel <nigel(dot)defreitas(at)verisk(dot)com>
wrote:
>
> *select* regexp_replace('Nigel DeFreit a s', E
> '[\s+|"]|[\n\r\f\a\t]|[^[:ascii:]]','','g') *AS* *result*;
>
>
>
Don't use E strings when writing regex. It adds a whole other layer of
backslash escaping that you really don't want to deal with.
David J.