Find and Replace - Regular Expression | Google Sheets Tutorial 25
In this lesson, We are going to explore:
0:00 Getting started.
0:27 Finding the countries' names that start with a lowercase by using the REGEX pattern.
1:14 Analysing of this REGEX pattern ^[a-z].*(\s[a-z].*)*(\s[a-z].*)*
All explanations are simple and to the point.
#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...
Worldometer | Countries in the World:
https://www.worldometers.info/geograp...
The whole playlist link:
• How to Use Google Sheets - Detailed T...
Follow us on Pinterest:
https://www.pinterest.it/GoogleWorksp...
Sound from Zapsplat.com
Welcome back to the second part of the Find and Replace lesson.
How to find the words that start with a lowercase using the REGEX?
We are going to use this REGEX pattern ^[a-z].*
No worry about the meaning of these symbols.
All will be clear in this exercise.
We wonder if there are some countries’ names that start with small letters.
Open Find and replace window.
Type the REGEX pattern ^[a-z].*
And activate these two checkboxes.
Click Find.
And here is it.
Let’s analyse this REGEX pattern ^[a-z].* and build a more complex one.
^ If a caret is at the beginning of the entire REGEX pattern it matches the beginning of a line.
[ ] Inside the square brackets, we type what we want to be matched.
a-z Match all lower case letters from ‘a’ to ‘z’
The dot is a special character used to match any one character.
The asterisk matches characters that occur zero or more times.
^[a-z].* this pattern matches any word that starts with a small letter followed or not by another character/s.
This pattern matches the country name that consists of one word and starts with a small letter.
But what about the name that consists of 2 or 3 words?
We need to modify the pattern.
By placing part of the regular expression inside parentheses we group that part of the REGEX to apply a quantifier to the entire group.
\s it is used to find a whitespace character.
This pattern matches any word that starts with a small letter followed or not by whitespace then another word that starts with a small letter.
To match also the third word, repeat this part of the pattern (\s[a-z].*)*.
Let’s test the pattern to be sure that everything works correctly.
Type the pattern and activate the checkboxes.
Click Find.
Click Find again.
Click Find again.
That’s it, have fun. Thanks for watching.
If you like the video, please give us a thumbs up.
And subscribe to our channel.
