On 11/02/2019 22:22, Dimitry Sibiryakov sd@...
[firebird-support] wrote:

> 11.02.2019 22:18, Lester Cainelester@... [firebird-support] wrote:
>> Ideally I need to extract the 'V' element and the 'p' element into their
>> own fields so I can look up Volume '12' and page '234' or list all the
>> pdf's for Volume '12' in page order.
> You could use "Regular expression SUBSTRING" described in
> firebird3/doc/README.substring_similar.txt.

Would help if we did not have to rely on a variable target :(

I've got
https://www.firebirdsql.org/file/documentation/release_notes/html/rlsnotes253.html#rnfb25-dml-regex
which the FB3 release notes link back to ...

AH ... on a linux installation for SUSE it's hidden in
/usr/share/doc/packages/firebird/sql.extensions but it's even less
helpful than the online page.

None of the examples show pulling the 'content of the second match' to
insert in an update statement? They all seem to be returns for Boolean
operations?

--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk