Скачать или смотреть Capturing Group VS Non-Capturing Group| REGEX Formulas 75

In this part, we are going to explore:
0:00 Getting started.
0:08 REGEX - What are a capturing group, a non-capturing group, and an indication group?
All explanations are simple and to the point.
Feel free to make your copy of this spreadsheet:
https://docs.google.com/spreadsheets/...

#GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Ben Collins (Google Developer Expert & Data Analytics Instructor)
https://www.benlcollins.com/

Google Sheets training:
https://support.google.com/a/users/an...

The whole playlist link:
   • The most useful formulas - Google Sheets |...  

Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...

Sound from Zapsplat.com

Apple logo
https://iconscout.com/contributors/pi...

Windows logo
https://pixabay.com/it/users/

Welcome back, Educators.
What are a capturing group, a non-capturing group, and an indication group?
Our mission is to extract the word industry in all these cases.
First, we use the REGEXMATCH function using this pattern.
It returns TRUE because we use the OR operator.
And this is the result when we use the REGEXEXTRACT function.
That is because we’ve two capturing groups in this pattern.
Every group is in a separate cell, and the function returns just the capturing groups.
By adding ?: to the group, becomes a non-capturing group.
And all the string that matches the pattern is in one cell.
Our mission is to extract this number from these strings.
For this exercise, we use the REGEXEXTRACT function.
This pattern extracts the first number in the string and that we don’t need.
Add (?:M) to the pattern.
The extraction starts when there is a digit or a dot followed by M.
This is an indication group.
For the second string, we add whitespace then the word million.
By grouping the first part, it becomes a non-capturing group.
And it doesn’t extract the M.
And this is the pattern for the second string.
We could add both to one pattern using the OR operator.
If we have one group in the pattern with (?:), it is an indication group.
If we have two groups in the pattern, the one with (?:) is a non-capturing group.
If we have two groups in the pattern, and both with (?:), it returns the same result of one group with (?:).
If we have two groups in the pattern, and both without (?:), it returns each group in a separate cell.
See you soon in the next part of this lesson.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.