David Lynch writes:
>On the other hand, if I enter =REGEX("29791","(?=(29|79|97))",,1)
>
>I get a zero length string.
>
>Can anyone help please?https://stackoverflow.com/questions/1570896/what-does-mean-in-a-regular-expression (?=pattern) is a zero-width positive lookahead assertion. For example, /\w+(?=\t)/ matches a word followed by a tab, without including the tab. So it looks to me like you are trying to match nothing followed by a 29, and you are successfully matching nothing. =REGEX("29791","((78|87))",,1) tells me "#N/A" , which I suppose is what you get when a regex fails. Yours succeeds and returns an empty string. --hymie! http://nasalinux.net/~hymie [email protected] -- To unsubscribe e-mail to: [email protected] 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
