Sample Header Ad - 728x90

Problem using Numbers Regex.Extract function

2 votes
2 answers
641 views
I need help with the following Apple Numbers REGEX.EXTRACT formula that doesn’t return the word before a dot. Below are the text form of the arguments passed to the formula and the formula itself as well as a screenshot.
Pattern: \b\w+\b(?=\.)
String: 123. xpto.
Formula: REGEX.EXTRACT(“123. xpto.”, \b\w+\b(?=\.),1)
why “123” not “xpto”
Asked by SIT123 (21 rep)
Jun 25, 2023, 10:17 AM
Last activity: Jun 5, 2025, 08:02 PM