On 12/02/2019 09:34, Mark Rotteveel mark@...
[firebird-support] wrote:

> You may want to look at the discussion "substring similar - "Invalid
> SIMILAR TO pattern"" on the 5th of December 2018.
>
> In your case, you will need 3 separate substrings:
>
> select x,
> substring(x similar 'V#"[[:DIGIT:]]+#"%.pdf' escape '#') as VERSION,
> substring(x similar 'V[[:DIGIT:]]+ p#"[[:DIGIT:]]+#" %.pdf' escape
> '#') as PAGE,
> substring(x similar 'V[[:DIGIT:]]+ p[[:DIGIT:]]+ #"%#".pdf' escape
> '#') as TITLE
> from (
> select 'V12 p234 The state of the nation.pdf' as x
> from rdb$database
> ) a
>
> You need to provide a full match, and the part you want to extract
> should be enclosed in double quotes, but those double quotes most be
> escaped (I used # here).

Thanks Mark ... just the kick I needed ...

OK looks like the first thing I was missing is that this only works in
FB3? Despite referencing FB2.5 release notes to expand the expressions?
Typically the data I'm working with is still on the FB2.5 server ;)

Also is the 'TO' optional? Apparently it's not used, so why is shown in
the FB3 release notes?

SO now I need to transfer the data over to an FB3 server so I can do it
for real rather than on a hacked copy of employee ...

--
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