using SA 220.127.116.119, I'm having troubles with the regexp_substr() function when used with a starting offset and a pattern including the "start of string" marker (i.e. the caret sign).
I would expect the "start of line" marker to apply to the offset, i.e. I would expect that the 2nd example would look for a pattern starting with offset 5.
But that doesn't seem to be the case.
Anyone to confirm this behaviour?
Addition: Would this mean if I want to check for a string that starts with a certain pattern at a particular offset, I would not use the start-offset parameter of regexp_substr() but would instead call this function for the particular substring, i.e.
? That would work as wanted.
@Volker: You are correct, the output from your second example should be 'abcd', not null. The current behaviour is a bug and will be corrected in a future EBF.
As a work-around, you can use your suggested rewrite. i.e.
is the same as
Thank you for reporting the issue.
answered 20 Jan '10, 18:11
I can confirm this behaviour for 18.104.22.1681.
answered 20 Jan '10, 15:39