On 11/02/2019 22:22, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 11.02.2019 22:18, Lester caineles...@lsces.co.uk [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' o
On 11/02/2019 22:51, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> It may be more convenient to pull out data via a Regex expression in SQL
> code but it is rather redundant since all of the major development
> languages already support extensive Regex pattern matching capabilities
I believe this has been done with such database engines as SQL Server and
PostgreSQL.
However, the Firebird Database Engine has a stricter standard as to what is
implemented in the SQL language than other such engines. Nonetheless, it
appears that there is some similar capabilities as th
11.02.2019 22:18, Lester Caine les...@lsces.co.uk [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 expressio
I have some data in a table which I need to 'pull apart'. It's
essentially a ID for a reference but it's not as tidy as I would like
because of the variable length and a little variable in case although
the format is consistent.
V p .pdf
For example 'V12 p234 The state of the nation.pdf'
Ideal