Problem using Numbers Regex.Extract function

Question

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)

Answer 1

I found two following solutions. I prefer lookaround for shorter formula.

Answer 2

If I understood well, you want to return any word that is immediately followed by a dot in a given string. In the example you provided, the function

REGEX.EXTRACT(“123. xpto.”, `\b\w+\b(?=\.)`,1)

should return "The formula contains a syntax error", since the Regex's syntax is incorrect.

Here is how your Regex parameter should look like: (\b\w+\b)\. Adding parentheses around \b\w+\b make it capture the entire word before the dot. You also need to encapsulate the Regex with double quotes (no single quotes or tildes).

The modified function would look like this:

Regex.Extract("123. xpto.", "(\b\w+\b)\.", 1)

And it should return "123."