Square Brackets VS Parentheses | REGEX Formulas 71

In this part, we are going to explore:
0:00 Getting started.
0:10 REGEX terms - What is the meaning of a character, a string, and a word in Regular expression?
0:47 REGEX pattern - the square brackets VS the parentheses.
2:44 REGEX pattern - The OR operator (pipe).
All explanations are simple and to the point.
Feel free to make your copy of this spreadsheet:

#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:
Query Language Reference:

Ben Collins (Google Developer Expert & Data Analytics Instructor)

Google Sheets training:

The whole playlist link:

Follow us on Pinterest:

Apple logo

Windows logo

Welcome back, Educators.
Let’s explore the difference between the square brackets and the parentheses.
We need first to clarify some of the REGEX terms.
The regex characters include:
Letters, numbers, symbols, space between the lines, words, and word borders.
The REGEX stringiest consists of one or more of these characters.
The REGEX word includes:
Letters (even a single letter)
Numbers (even a single digit)
Symbols and whitespace and newline characters don’t consider words in REGEX.
For this exercise, we use the REGEXEXTRACT function.
We use the same REGEX pattern. The only difference is the [ ] and ( ).
When we use this pattern, it returns N/A.
When we use this pattern, it returns the entire string.
In this pattern, the dot is a special character.
In this pattern, the dot represents the dot itself.
This pattern means a single digit, followed by a comma, followed by any single character, followed by the euro symbol.
This pattern means one or more of a digit or comma or dot or the euro symbol.
The plus rule applies for each character inside the square brackets.
The plus rule applies to the entire group, not to every single character inside it separately.
This pattern is valid for a string like this one.
Using this pattern will return the entire string.
Using this pattern will return the first digit only.
Using this pattern will return the entire string.
Using this pattern will return the dot only.
Using this pattern with the REGEXMATCH, return TRUE.
This pattern means: is there a digit, a comma, dot, or euro symbol (one or more of them) in these strings?
To achieve the same result, we add the pipe symbol, which means OR, using the parenthesis.
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.

[GoogleWorkspaceTutorial]

In this part, we are going to explore:
REGEX terms - What is the meaning of a character, a string, and a word in Regular expression?
REGEX pattern - the square brackets VS the parentheses.
REGEX pattern - The OR operator (pipe).
All explanations are simple and to the point.
Feel free to make your copy of this spreadsheet:

[safyiaalwadi]

الامدريسي العبقري الحادق لك دعاءي وجزيل شكري وتقديري صبحك الله تعالى وبركاته يديم علينا نعمة ويسلم يداك لك حق عليه تعلمت منك الكثير

[Moujid]

الإدريسي العبقري الحاذق وسلم يداه وبارك له بكل أموره له حق علينا تعلمنا منك الكثير الله يصبرك ويسلم يداك علت كل حرف تعلمت منك الكثير

[Moujid]

يالله يارباه ديم لنا أستاذنا العبقري الحاذق وسلم يداه وبارك له بكل أموره له حق علينا تعلمنا منك الكثير الله يصبرك ويسلم يداك علت كل حرف تعلمت منك الكثير الله يصبرك ويسلم يداك علت

[safiaalwadi]

المهم لك سجدنا وعليك توكلنا دم لنا جميعاً من رحمتك برحمتك ساعدمدريسي العبقري الحاذق

[npwzpre]

ياالله صبح صبح صبح مد لي ولا يحرمني منك يامدريسي