Re: regexp_replace

On Jul 23, 2007, at 9:50 AM, polen(dot)t2006(at)freenet(dot)de wrote:
> fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string)

Add a 'g' flag:

fieldname=regexp_replace(fieldname,old_sub_string,new_sub_string, 'g')

From the end of a paragraph in 9.7.3 just before 9.7.3.1:

> The flags parameter is an optional text string containing zero or
> more single-letter flags that change the
> function’s behavior. Flag i specifies case-insensitive matching,
> while flag g specifies replacement of each
> matching substring rather than only the first one.

Perry Smith ( pedz(at)easesoftware(dot)com )
Ease Software, Inc. ( http://www.easesoftware.com )

Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems