How do I use non capturing groups in google sheets?

Question

This is what I intend to do.

But a similar one doesn't work.

As with any problem I post, I still can't solve it after more than two hours of trying. :-(
https://github.com/google/re2/wiki/Syntax

Tedinoz · Answer

Try:
={REGEXEXTRACT(D2,"ing?"),REGEXEXTRACT(D2,"ziggo")}
Your example in the question can be written as follows:
={REGEXEXTRACT(A1,"banana"),REGEXEXTRACT(A1,"berry")}

How do I use non capturing groups in google sheets?

One Answer

Add your own answers!

Ask a Question