[libreoffice-users] REGEX difficulty

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 get a zero length string.

Can anyone help please?

David Lynch

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; 
VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded


--
To unsubscribe e-mail to: users+unsubscribe@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