ODP: [firebird-support] Built in RegEx Capability?

Hi. For your particular case you do not need regex at all. Simple substring + position. Example: Select D.NAZWA , SUBSTRING(D.NAZWA FROM POSITION('V', D.NAZWA)+1 FOR POSITION('p', D.NAZWA)-3) AS V , SUBSTRING(D.NAZWA FROM POSITION('p', D.NAZWA)+1 FOR POSITION(' ', SUBSTRING(D.NAZWA FROM POSITI

Re: ODP: [firebird-support] Built in RegEx Capability?

On 12/02/2019 16:36, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] wrote: > Select > D.NAZWA > , SUBSTRING(D.NAZWA FROM POSITION('V', D.NAZWA)+1 FOR POSITION('p', > D.NAZWA)-3) AS V > , SUBSTRING(D.NAZWA FROM POSITION('p', D.NAZWA)+1 FOR POSITION(' ', > SUBSTRING(D.NAZWA FRO

Re: ODP: [firebird-support] Built in RegEx Capability?

On 2019-02-12 18:50, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 12/02/2019 16:36, Karol Bieniaszewski liviusliv...@poczta.onet.pl > [firebird-support] wrote: >> Select >> D.NAZWA >> , SUBSTRING(D.NAZWA FROM POSITION('V', D.NAZWA)+1 FOR POSITION('p', >> D.NAZWA)-3) AS V >> , SUB