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' 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 ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/