Re: DB2 regex bug with look around ?

On Thu, Apr 28, 2016 at 5:58 AM, Craig Richards <craig@xxxxxxxxxxxxxxxx> wrote:

If you check the regex and the string it's applied to, and ignore my typos
( sorry ) I think you'll find it doesn't select the correct matched text (
or else my understanding is wrong )

Well, we don't have a high enough TR on our 7.1 system for me to test
this directly, but I tried it in Python, which I think should behave
the same in this case.

The search may not be returning anything other than success or failure
unless you have something to capture. It's telling you it found the
pattern, but that's all. To return the digit, try surrounding the \d
in parens:

'(?<!a)(\d)(?!a)'

John Y.