Hi David,
On Fri, 2021-05-21 at 17:19 +0100, David Lynch wrote:
> If I use the REGEX tester <https://regex101.com/>
> with regular expression (?=(29|79|97))
> and test string 29791
> I get 3 matches 29, 97,79, as I expect.
> On the other hand, if I enter =REGEX("29791","(?=(29|79|97))",,1)
I think you have to escape the parentheses vis:
=REGEX("29791","\(?=\(29|79|97\)\)",,1)
that yields 79
Regards,
Tony.
--
Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT
Services | Office 1, Kilburn Building | The University of Manchester |
Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 0039
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
